http://sqlblog.com/blogs/eric_johnson/archive/tags/SQL+Server/T-SQL/default.aspxTags: SQL Server, T-SQLenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/eric_johnson/archive/2010/03/04/sql-server-2008-s-merge-statement.aspxThu, 04 Mar 2010 16:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22702ejohnson20102http://sqlblog.com/blogs/eric_johnson/comments/22702.aspxhttp://sqlblog.com/blogs/eric_johnson/commentrss.aspx?PostID=22702SQL Server 2008 provided us with some new T-SQL syntax; one of those that I am most excited about is the new MERGE statement. Gone are the days of IF....THEN logic to decide whether a row needs to be inserted, updated, or deleted. The MERGE allows you...(<a href="http://sqlblog.com/blogs/eric_johnson/archive/2010/03/04/sql-server-2008-s-merge-statement.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=22702" width="1" height="1">SQL ServerT-SQLhttp://sqlblog.com/blogs/eric_johnson/archive/2010/03/01/using-sql-server-2008-s-except-and-intersect-statements.aspxMon, 01 Mar 2010 21:29:06 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22701ejohnson20105http://sqlblog.com/blogs/eric_johnson/comments/22701.aspxhttp://sqlblog.com/blogs/eric_johnson/commentrss.aspx?PostID=22701SQL Server 2008 shipped with several enhancements to the T-SQL language. In a recent blog, we looked at the new MERGE syntax; today we are going to look at the new EXCEPT and INTERSECT syntax. Both of these operators allow you to compare results of two...(<a href="http://sqlblog.com/blogs/eric_johnson/archive/2010/03/01/using-sql-server-2008-s-except-and-intersect-statements.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=22701" width="1" height="1">SQL ServerT-SQL