insert into tblperson2 values(3,'vandana'); -- there is a error when a column list is used and IDENTITY_INSERT is ON. set IDENTITY_INSERT tblperson2 on; insert into ...