SQL Server Archives - Filjan, Inc.

Primary Key

August 3, 2019August 3, 2019 - by filjan

A primary key is used to uniquely identifies a record. A key is used to sort, compare and create a relationship between records. There are some basic rules to follow …

SQL Server

Using The SQL IN and NOT IN

September 30, 2018 - by filjan

If you wanted to search a bunch of values, you would write a WHERE clause with the values joined by the OR operator. A more readable WHERE clause would be …

SQL Server

Renaming The Output Columns In SQL

September 10, 2018September 10, 2018 - by filjan

If you need to change the name of the column returned by a query use can use the “AS” clause. Without the AS clause, the returned column name will be …

SQL Server

Northwind Sample Database

October 15, 2014October 15, 2014 - by filjan

To download the Northwind sample database, go here. http://www.microsoft.com/en-us/download/details.aspx?id=23654 To download the Adventure Works sample database, go here. http://www.microsoft.com/en-us/download/details.aspx? Id=10679