SQL Server Multi-Table Queries
This post serves as a series of links to the different kinds of multi-table queries. The Microsoft Press […]
table
SQL Sever Many-To-Many
Do you have a database that has two tables that have a many-to-many relationship? What do I mean […]
SQL Server Left Joins Simplified
In order to more easily understand left joins we will modify Itzik Ben-Gan’s database from the previous post […]
SQL Server Common Table Expressions CTE
Common table expressions (CTEs) are another kind of table expression that like derived tables are visible only to […]
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 […]