SQL Server Case
The SQL Server Case statement is best explained by example. What Case allows us to do is get […]
Daily Archives: August 11, 2017
SQL Server Intersect
INTERSECT says “give me what’s common to both” as the word itself implies. It is the intersection of […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
SQL Server Integer Data Types
Here is a table showing the integer types of SQL Server from the Microsoft website. INT goes up […]
SQL Server Union
This article is discussing the combining of two or more tables using UNION or UNION ALL into one […]