摘要： SQLServer2005通过intersect,union,except和三个关键字对应交、并、差三种集合运算他们的关系对应如下createtablet1 (aint)insertintot1select1unionselect2unionselect3createtablet2 (aint)insertintot2select3unionselect4unionselect5goselect*fromt1unionselect*fromt2go/* 求表并集12345*/select*fromt1unionallselect*fromt2go/*求表并集不过滤重复123345*/selec 阅读全文