SQL Server Merge
Sometimes in SQL Server you need to create a summary table from a transaction table. Transactions are coming […]
SQL Server
SQL Server Case
The SQL Server Case statement is best explained by example. What Case allows us to do is get […]
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 […]
SQL Server Inserting Into Views
Suppose we have a view that we can select to see the rows and columns of the underlying […]
SQL Server Views
A SQL Server view is a type of table expression. A View is stored in the database (with […]
SQL Server Security
Schema and Views The dbo stands for database owner. It is the schema. Objects can be grouped together […]
SQL Server Documentation
There are several ways to document a database. This post will only discuss some of the queries you […]
SQL Server Extended Properties Part 2
This article discusses how to view extended properties in a SQL Server database. Our previous article discussed how […]
SQL Server Extended Properties
This article defines SQL Server extended properties. We discuss adding, editing and deleting them. In the next article […]