备份表
SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_tablename
必须显示的表名字段名:
SET IDENTITY_INSERT del ON
insert into del(id,birthday) select id,birthday from del --标明字段名
SET IDENTITY_INSERT del OFF
转载于:https://www.cnblogs.com/kevin1988/p/3503058.html