两个表Table1,Table2结构相同,都含有Identity列ID,要把Table2的内容复制到Table1 SET IDENTITY_INSERT Table1 ON
Insert into Table1(ID, username, email)select ID, username, email from Table2 SET IDENTITY_INSERT Table1 OFF