How to Insert a value into an Identity column using SET IDENTITY INSERT statement T-SQL Script #3

If you want to insert a value into an identity column, you can use the SET IDENTITY_INSERT statement.
When inserting into an identity column, you must explicitly list each column in the column list. Sql Server (T-SQL)