delete from gzyExam_s_c.dbo.Roles set identity_insert gzyExam_s_c.dbo.Roles on insert into gzyExam_s_c.dbo.Roles(id,rolename,issysrole,permision) select id,rolename,issysrole,permision from gzyexam_c.dbo.Roles set identity_insert gzyExam_s_c.dbo.roles off
发现的我问题：
同时只能有一个表set identity_insert table on
必须为上一次的on 设置为off 才能设置其他的表为 On