Insert data into Identity Column

Query to insert data into identity column



SET IDENTITY_INSERT  [TABLENAME] ON 


INSERT INTO [TABLENAME]
(IDENTITYCOLUMN, COLUMN1, COLUMN2 ,COLUMN3)
VALUES 
(1, 'COLUMN VALUE1' , 'COLUMN VALUE2' , 'COLUMN VALUE3'   )


SET IDENTITY_INSERT  [TABLENAME] OFF