CODE EXAMPLE FOR SQL

insert value in identity

SET IDENTITY_INSERT <table_name> ON
-- execute this before inserting values in idenity

-- example
SET IDENTITY_INSERT Customer ON  
INSERT INTO Customer(ID, Name, Address)  
VALUES(3,'Prabhu','Pune')