SQL 2005 except,intersect PENGHAO 查找b表中不在a表中的数据 select * from #b except select * from #a 查找a,b两个表的交集 select * from #b intersect select * from #a