How To Insert Value In Identity Column Manually in SQL Server Table - SQL Server / T-SQL Tutorial Part 41

Scenario: 

We have a dbo.Customer table that has ID as identity column. We need to insert one record in this table with -1 for ID.

Solution :

We will be using Identity_insert ON and Off to do this as shown below.It will disable identity property and then we will insert record and then enable it back.

CREATE TABLE dbo.Customer(
  ID INT IDENTITY(1,1)
, CustomerCode VARCHAR(50)
, FirstName VARCHAR(50)
, LastName VARCHAR(50))

SET IDENTITY_INSERT dbo.Customer ON
 GO
INSERT INTO dbo.Customer ( ID,CustomerCode,FirstName,LastName)
VALUES (-1,'UNKNOWN','UNKNOWN','UNKNOWN')
SET IDENTITY_INSERT Dbo.Customer OFF

SELECT * FROM dbo.Customer


How to insert value in Identity Column manually in SQL Server Table


Video Demo :  How to manually insert the value in identity column in SQL Server Table