devxlogo

Insert Explicit Values into the Identity Column of a Table

Insert Explicit Values into the Identity Column of a Table

For inserting explicit values into the identity column of a table, IDENTITY_INSERT property is set to ON.

 Table tblName has got following fieldsCompanyID INT IDENTITY(1,1)CoName VARCHAR(75)

And following the data:

 CompanyID	CoName1		Starcraft Corporation2		Holobeam Inc3		OnSpan Networking Inc4		CaminoSoft Corp.5		OMNI Rail Products IncInserting rows with explicit value for CompanyIDSET IDENTITY_INSERT tblName ONINSERT INTO tblName(CompanyID,CoName) VALUES(10,' Globix Corporation')INSERT INTO tblName(CompanyID,CoName) VALUES(6,'Teltone Corp')

After these insertions, the current identity value for the table tblName will be 10.

devx-admin

Share the Post: