Monthly Archives: November 2009

Sql Server – Union and Union All

Union and Union All, both are used to select data from one or more than one tables but still they have some differences. For Example, Union is used to select distinct data from the tables but Union All allows duplicate … Continue reading

Posted in SQL Server, SQL Union Function | Tagged | 31 Comments

IDENTITY Property in SQL Server

  IDENTITY  Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose, this column should contains the unique values and it can’t contains the NULL or empty values. We can … Continue reading

Posted in SQL Basic Concepts, SQL Server | Tagged , | 33 Comments