MSSQL 中如何判断两个表的所有数据是否相同(两个表的字段已经相同)

--假设分别是A表和B表，sql 如下：declaretableA_count number;tableB_count number;C_tableA CURSOR;begin select count(1) into tableA_count from A ;select count(1) into tableB_count from B ;C_tableA is selct * from A;if tableA_count=tableB_count then for C_cursor in C_