SQL Server Common Table Expressions CTE
Common table expressions (CTEs) are another kind of table expression that like derived tables are visible only to […]
table
SQL Server Create Table
You can create a table using the SSMS GUI, or you can use T-SQL code. This post describes […]
SQL Server Insert Into Select Part 1
This post discusses how to insert data from one table into another existing table. The second table must […]
SQL Server Table Expressions
What is a table expression? Table expressions are named query expressions that represent a valid relational table. Table […]
SQL Server Insert Into Select Part 2
This post shows you how to insert data into an existing empty table from two other tables using […]
SQL Server Changing Table Structure
The table structure refers to the columns in the table. We can use T-SQL to add a new […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
SQL Server Temp Table to Pass Data Between SProcs
Do you have a series of stored procedures in SQL Server that need to pass data between themselves? […]
SQL Server Import Data from a Text File Part 2
This post is a continuation of the first post. In this example we are working with a text […]
SQL Server Exporting a Table to a Text File Part ...
This post continues from the first part. In this example the directory has a space in it so […]
SQL Finding Duplicates across Two Tables Two Columns
This blog post is a continuation from the previous blog post called SQL Finding Duplicates across Two Tables […]
T-SQL Bulk Insert-Output Part 6
This post continues from our other post called T-SQL Bulk Insert-Output Part 5. In this post we will […]