2012计算机三级网络技术基本概念与名词解释17
查看硬盘分区:
EXEC master..xp_fixeddrives
比较A,B表是否相等:
if (select checksum_agg(binary_checksum(*)) from A)
=
(select checksum_agg(binary_checksum(*)) from B)
print '相等'
else
print '不相等'
EXEC master..xp_fixeddrives
比较A,B表是否相等:
if (select checksum_agg(binary_checksum(*)) from A)
=
(select checksum_agg(binary_checksum(*)) from B)
print '相等'
else
print '不相等'