★ 两个数据库的表如何判断数据是否一样?急,在线等待…… ★ select *from s1..t1where s1..t1.ddh not in (select ddh from s2..t2 ) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from t1 where not exists (select 1 from t2 where t1.xh=t2.xh and t1.hh=t2.hh) select * from s1..t1 t1 where not exists (select 1 from s2..t2 where t1.xh=t2.xh and t1.hh=t2.hh) 这个是对的select * from s1..t1 t1 where not exists (select 1 from s2..t2 t2 where t1.xh=t2.xh and t1.hh=t2.hh) select *from s1..t1where t1.ddh not in ( select ddh from s2..t2 )and t1.hh not in( select hh from s2..t2 ) select * from s1..t1 t1 where not exists (select 1 from s2..t2 t2 where ^这个1代表是什么意思啊? t1.xh=t2.xh and t1.hh=t2.hh) select * from s1..t1 as 别名1 where not exists (select 1 from s2..t2 别名2 where 别名1.xh=别名2.xh and 别名1.hh=别名2.hh)1是简写,普通是*,字段名,这样就少了返回值 我将一个excel中的数据导入到sql数据库的错误 bat导出数据问题 怎么用存储过程判断一个表是否存在? 又来送分 菜鸟问题:create table 如何处理循环调用,循环导入表格,并把表格连在一起 SQL2005的安装问题汇总 无法打开登录所请求的数据库 "Test"。登录失败。 关于sql server数据传输?有一定难度哦 从ACCESS导入数据到SQL SERVER遇到的一个奇怪问题, 请教各位大虾如何解决?(狂给分) 用sql语句删除表索引的问题 关于表的关系的问题!!!!
from s1..t1
where t1.ddh not in ( select ddh from s2..t2 )
and t1.hh not in( select hh from s2..t2 )
^这个1代表是什么意思啊?
t1.xh=t2.xh and t1.hh=t2.hh)