月底出事了,之二,求一个插入的语句 假设两表字段名依次为 a1,b1,c1,d1inser b select * from a where a.a1<>b.a1 and a.b1<>b.b1 and a.c1<>b.c1 and a.d1<>b.d1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 假设两表字段名依次为 a1,b1,c1,d1inser b select * from a where a1 not in(select a1 from b)行否? 假设两表字段名依次为 a1,b1,c1,d1inser b select * from a where not exists (select 1 from b where a.a1=b.a1 and a.b1=b.b1 and a.c1=b.c1 and a.d1=b.d1) insert into bselect * from a where id not in (select id from b)orinsert into bselect * from a where not exists(select 1 from b where a.id = b.id) 关于 set IDENTITY_INSERT 的问题 求一个触发器 excel导入到数据库发生错误.怎么解决???? 求一条简单sql语句 给数据库添加用户的问题 分组并更新组内的信息,帮忙思考一下______thank you 请问,如何用sql语句实现排除问题! 这样苛刻的数据同步SQL Server能实现吗?请高手指点。 SQL Server7.0能监视SQL Server2000建的数据库吗? paradox表好象不支持这种日格式的插入操作 这样做的好处是什么? 关于跨数据库建立试图的问题??
inser b select * from a where a1 not in(select a1 from b)
行否?
inser b
select * from a
where not exists (
select 1 from b
where a.a1=b.a1 and a.b1=b.b1 and a.c1=b.c1 and a.d1=b.d1
)
select * from a where id not in (select id from b)orinsert into b
select * from a where not exists(select 1 from b where a.id = b.id)