仅当使用了列列表并且 IDENTITY_INSERT 为 ON 时，才能为表'Area'中的标识列

admin

原来的代码是：

[mw_shl_code=sql,true]insert Group1
select * from(
select * Group2
union
select * from Group3
union
select * from Group4
)t[/mw_shl_code]


现在的代码是：

[mw_shl_code=sql,true]insert  Group1
select * from(
select QQNum,Nick,Age,Gender,Auth,QunNum from Group2
union
select QQNum,Nick,Age,Gender,Auth,QunNum from Group3
union
select QQNum,Nick,Age,Gender,Auth,QunNum from Group4
)t[/mw_shl_code]

成功解决！！