SET IDENTITY_INSERT del ON insert into del(id,birthday) select id,birthday from del --标明字段名 SET IDENTITY_INSERT del OFF