首先复制表_copy 将原表中需添加的标识字段删除并重新添加字段并标识
truncate table t_role_resources;
set identity_insert t_role_resources on;
INSERT into t_role_resources([id], [role_id],[resources_id]) SELECT [id], [role_id],[resources_id] from t_role_resources_copy;
set identity_insert t_role_resources off;