How can a column in SQL table made as Identifier column

SQL Interview Questions, SQL Server Articles 1 Minute

IDENTITY  property

Identified column can be implemented using IDENTITY property. While specifying IDENTITY column, you specify SEED and ARGUMENT.

SYNTAX :

IDENTITY [ (seed , increment) ]

When inserting rows into table with IDENTITY column , SQL Server automatically generates next identity value by adding increment to previous identity value.

FACTS :

  1. Only one column in a SQL table can be defined with IDENTITY property.
  2. IDENTITY column can be defined on decimal , int , numeric , smallint , bigint or tinyint data type column.
  3. Default increment value is 1
  4. Identity value is assigned in ascending order by default
EXAMPLE :
1. Create a table with IDENTITY column using create table script

CREATE TABLE Employee
(
 EmpNumn int IDENTITY(1,1),
 Name varchar (200),
 Email varchar(100)
);


2. Identity column using SQL Server Enterprise Manager










	


	

			


	

				

			Published
					

	




			
	
			



	
	
	
	
		

							
Leave a Reply