若表2不存在: select identity(int,1,1) as ID,a as BB,c as CC into 库B..表2 from 库A..表1否则: select identity(int,1,1) as ID,a,c into #tmp from 库A..表1 insert 库B..表2(ID,BB,CC) select * from #tmp
你的ID是自增的吗? 是的话,直接复制就行:insert into 库2..表1 (bb,cc) select a,c from 表1
请问怎么让ID 自增? 把id设为标识列就可以拉。。 如create table test(id int identity(1,1)) 这样就是标识列insert into 库2..表1 (bb,cc) select a,c from 表1 或 如果id不是标识列select identity(int,1,1) as id,a,c into #tmp from 表1 insert into 库2..表1 (id,bb,cc) select id,a,c from #tmp
select identity(int,1,1) as id,a as bb ,c as cc into databaseB..表2 from 表1
--如果表2不存在,可以直接用: select id=identity(int,1,1),bb=a,cc=c into databaseB..表2 from 表1 --如果表2存在,有id字段,id不是标识字段 select id=identity(int,1,1),a,c into #t from 表1 insert into databaseB..表2 select * from #t drop table #t--如果表2存在,有id字段,id是标识字段 insert into databaseB..表2(bb,cc) select a,c from 表1
select identity(int,1,1) as ID,a as BB,c as CC into 库B..表2 from 库A..表1否则:
select identity(int,1,1) as ID,a,c into #tmp from 库A..表1
insert 库B..表2(ID,BB,CC) select * from #tmp
把id设为标识列就可以拉。。
如create table test(id int identity(1,1)) 这样就是标识列insert into 库2..表1 (bb,cc) select a,c from 表1
或
如果id不是标识列select identity(int,1,1) as id,a,c into #tmp from 表1
insert into 库2..表1 (id,bb,cc) select id,a,c from #tmp
select id=identity(int,1,1),bb=a,cc=c into databaseB..表2 from 表1
--如果表2存在,有id字段,id不是标识字段
select id=identity(int,1,1),a,c into #t from 表1
insert into databaseB..表2 select * from #t
drop table #t--如果表2存在,有id字段,id是标识字段
insert into databaseB..表2(bb,cc) select a,c from 表1
INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_INVESTOR_RELATION__VL_REGIO' 冲突。该冲突发生于数据库 'test',表 'VL_REGION', column 'RegionID'。
语句已终止。