Create Table SQL Script in Excel
You have some data in Excel that you need to import into SQL Server. You don’t have a […]
table
SQL Server Heap
Preliminary Information A table can be organized one of two ways: heap or B-tree. If a table has […]
SQL Server Multi-Table Queries
This post serves as a series of links to the different kinds of multi-table queries. The Microsoft Press […]
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 […]