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 Server
SQL Server Cross Joins
Cross joins are one of the three fundamental types of joins: cross, inner and outer. There are also […]
SQL Server Correlated Subqueries
Correlated subqueries have references known as correlations to columns in tables from tables in the outer query. They […]
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 Left Joins
This post gives an example of using left joins on a series of tables in the Itzik Ben-Gan […]
SQL Self-Contained Subqueries
This example comes from Ikzik Ben-Gan’s book T-SQL Querying. Subqueries are used to nest queries. Subqueries is a […]
Itzik Ben-Gan’s SQL Database
In Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […]
SQL Server Burton’s Database
There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […]
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 Summing Time
This post describes how you can sum a column with a data type of Time in SQL Server. […]