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.

See also  Comparing different methods of testing your Infrastructure-as-Code

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist