--必须显示的表名字段名:
SET IDENTITY_INSERT del ON
insert into del(id,birthday) select id,birthday from del --标明字段名
SET IDENTITY_INSERT del OFF
引用:http://topic.csdn.net/t/20050723/11/4163061.html
--必须显示的表名字段名:
SET IDENTITY_INSERT del ON
insert into del(id,birthday) select id,birthday from del --标明字段名
SET IDENTITY_INSERT del OFF
引用:http://topic.csdn.net/t/20050723/11/4163061.html