允许重复值 insert c select * from a union all select * from b去除重复值 insert c select * from a union select * from b
INSERT INTO C SELECT * FROM A union select * from B
INSERT INTO C SELECT * FROM A UNION ALL SELECT * FROM B WHERE FLD NOT IN (SELECT A.FLD FROM A)
insert c select * from a union select * from b 这种方法我试过了,报错: 违反了 PRIMARY KEY 约束 'PK_BASLogTemp'。不能在对象 'BASLogTemp' 中插入重复键。 语句已终止。
更正一下 insert c select * from a union select * from b 这种方法我已经试过了,报错: 违反了 PRIMARY KEY 约束 'PK_c'。不能在对象 'c' 中插入重复键。 语句已终止。
INSERT INTO C SELECT * FROM A UNION ALL SELECT * FROM B WHERE FLD NOT IN (SELECT A.FLD FROM A)
insert c select * from a union all --union 去除重复 select * from b注意如果存在着id自动唯一编号,则需要 set identity_insert c on insert c(id,col1,col2..) select * from a union all --union 去除重复 select * from b set identity_insert c
你A,B表中的主键是否跟C中的主键字段一样呢?
搞定了,sunsunup()最早给出正确答案, select * from a union select * from b直接用会出错的。
insert c
select * from a
union all
select * from b去除重复值
insert c
select * from a
union
select * from b
SELECT *
FROM A
union
select *
from B
SELECT * FROM A
UNION ALL
SELECT * FROM B WHERE FLD NOT IN (SELECT A.FLD FROM A)
insert c
select * from a
union
select * from b
这种方法我试过了,报错:
违反了 PRIMARY KEY 约束 'PK_BASLogTemp'。不能在对象 'BASLogTemp' 中插入重复键。
语句已终止。
insert c
select * from a
union
select * from b
这种方法我已经试过了,报错:
违反了 PRIMARY KEY 约束 'PK_c'。不能在对象 'c' 中插入重复键。
语句已终止。
SELECT * FROM A
UNION ALL
SELECT * FROM B WHERE FLD NOT IN (SELECT A.FLD FROM A)
select * from a
union all --union 去除重复
select * from b注意如果存在着id自动唯一编号,则需要
set identity_insert c on
insert c(id,col1,col2..)
select * from a
union all --union 去除重复
select * from b
set identity_insert c
select * from a
union
select * from b直接用会出错的。