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.