Set identity insert on off

We can insert specific value in column which has set identity by using SET IDENTITY_INSERT ON OFF option available in SQL Server.

Here i have one table which has UserID column as identity column

Example

generate error  when i try to insert specific value in UserID

INSERT INTO UserMaster 

(

UserID, 

UserName,

Password

)

VALUES

(

17,

'abc@gmail.com',

'Admin@123'

)

Solution for this issue in set identity ON
Code :

SET IDENTITY_INSERT UserMaster ON

INSERT INTO UserMaster
(
UserID,
UserName,
Password
)
VALUES
(
17,
'abc@gmail.com',
'Admin@123'
)

SET IDENTITY_INSERT UserMaster OFF

After insert SET IDENTITY_INSERT set to OFF so no need to pass user id every time

SET IDENTITY_INSERT UserMaster OFF