2012年1月2日
SQL Server 2005: Using EXCEPT and INTERSECT to compare tables
摘要： Previously, I had written that UNION ALL (combined with a GROUP BY) is a really quick and easy way to compare two tables. You don't need to worry about NULLS, the code is fairly short and easy to follow, and you can view exceptions from both tables at the same time.Well, now in SQL 2005, we have 阅读全文
posted @ 2012-01-02 17:44 叶de第柒章 阅读(380) 评论(0) 推荐(0)