Insert values into Primary Key or Auto-Generated Column

If we try to insert values into an Auto-generated column, then it will not allow us to insert data into Primary Key column but if there is a requirement that we must insert values in an Auto-generated column,to do this

With the help of Identity_Insert keyword, we can insert any numeric values to Auto-generated column


Set Identity_Insert Table_Name ON

//Write your insert query

Set Identity_Insert Table_Name OFF