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.