Vivek Johari

Sql Server – Union and Union All

Vivek Johari / November 17, 2009

Union and Union All, both are used to select data from one or more than one tables but still they […]

Vivek Johari / November 11, 2009

IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve

Vivek Johari / October 13, 2009

Database is made offline to move its physical files. There can be many ways to make a database offline. But

Vivek Johari / October 12, 2009

Introduction Tables can be defined as the structure which contains the data in the database. This article discuss about the

Vivek Johari / October 5, 2009

Both Primary key and Unique key enforce uniqueness of the column on which they are defined but still there are

Vivek Johari / September 29, 2009

Query Query can be defined as a way to inquire the data from the database. It is used to extract