我想把B数据库B1表的数据查出来导出到A数据库A1表内 运行下面的语句报错 A1表有个自动增长列 由于字段太多想找个简单的方法 请教
insert A.dbo.A1 select * from B.dbo.B1
An explicit value for the identity column in table 'ssm.dbo.Text' can only be specified when a column list is used and IDENTITY_INSERT is ON.
我这样做也不行
SET IDENTITY_INSERT A.dbo.A1 on
insert A.dbo.A1 select * from B.dbo.B1
insert A.dbo.A1 select * from B.dbo.B1
An explicit value for the identity column in table 'ssm.dbo.Text' can only be specified when a column list is used and IDENTITY_INSERT is ON.
我这样做也不行
SET IDENTITY_INSERT A.dbo.A1 on
insert A.dbo.A1 select * from B.dbo.B1
SET IDENTITY_INSERT OFF
2.导数据.
3.设置(更改)新表某字段为自增列.
select * into tb from