34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
天地客人 2005-09-06
- 打赏
- 举报
学习了!谢谢!
ljial 2005-09-06
- 打赏
- 举报
select * from a where not exists (select * from b)
if (@@row_count=0)
print '相同'
else
pring '不同'
if (@@row_count=0)
print '相同'
else
pring '不同'
tiger999 2005-09-06
- 打赏
- 举报
to zzxiaoma
intersect 吧, 怎么用 union 啊??
intersect 吧, 怎么用 union 啊??
Alisa 2005-09-06
- 打赏
- 举报
同意vivianfdlpw的
zzxiaoma 2005-09-06
- 打赏
- 举报
select aa from table1 where aa not in select aa from table2
union
select aa from table2 where aa not in select aa from table1
结果为空就相等
union
select aa from table2 where aa not in select aa from table1
结果为空就相等
itsakidding 2005-09-06
- 打赏
- 举报
即每一条语句都相等
vivianfdlpw 2005-09-06
- 打赏
- 举报
--比较A,B是否相等
if (select checksum_agg(binary_checksum(*)) from A)
=
(select checksum_agg(binary_checksum(*)) from B)
print '相等'
else
print '不相等'
if (select checksum_agg(binary_checksum(*)) from A)
=
(select checksum_agg(binary_checksum(*)) from B)
print '相等'
else
print '不相等'
