Eric Johnson : T-SQL

TSQL TRY…CATCH

ejohnson2010 — Tue, 12 Oct 2010 17:46:00 GMT

Transact-SQL is a great language for data manipulation, but it has its weaknesses. Unlike “real programming languages” T-SQL is confined to procedural code. Sure, you can build “modules” by using stored procedures and functions, but for the most part,...(read more)

New T-SQL Functionality in SQL Server 2008

ejohnson2010 — Mon, 15 Mar 2010 15:00:00 GMT

In my most recent posts I have looked at a few of the new features offered in T-SQL in SQL Server 2008. In this post, I want to take a closer look at some of the smaller additions, but additions that are likely to pack a big punch in terms of efficiency....(read more)

SQL Server 2008's MERGE Statement

ejohnson2010 — Thu, 04 Mar 2010 16:00:00 GMT

SQL 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...(read more)

Using SQL Server 2008's EXCEPT and INTERSECT Statements

ejohnson2010 — Mon, 01 Mar 2010 21:29:06 GMT

SQL 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...(read more)