Identity field is usually used as a primary key. When you insert a new record into your table, this field automatically assign an incremented value from the previous entry.
Ex:
CREATE TABLE Customer
(
ID int IDENTITY,
Name varchar(100),
Address varchar(200)
)
INSERT INTO Customer(ID,Name,Address) VALUES(1,'Shakham','Delhi')
This will return an errror message that you cannot insert values into identity column .
Disallow insert into identity field
SET IDENTITYINSERT Customer ON
INSERT INTO Customer(ID,Name,Address) VALUES(3,'Himanshu','Dehradun')
INSERT INTO Customer(ID,Name,Address) VALUES(4,'Suresh','Noida')
SET IDENTITYINSERT Customer OFF
INSERT INTO Customer(Name,Address) VALUES('Sumit,'Noida')
0 Comment(s)