archwhite
4/20/2016 - 2:38 PM

Insert row with specific primary id

Insert row with specific primary id

Set_ID_For_Row.sql
content_copyfile_download
SET IDENTITY_INSERT dbo.Tool ON;
INSERT INTO dbo.Tool (ID, Name) VALUES (3, 'Garden shovel');
SET IDENTITY_INSERT dbo.Tool OFF;
GO