Prior to SQL Server 2005, error handling was limited almost exclusively to the
@@error system function and the
RAISERROR statement, or through client-side exception handling. T-SQL in SQL Server 2008 still provides access to these tools, but also supports modern structured error handling similar to that offered by other high-level languages such as C++, C#, and Visual Basic. In this chapter, I will discuss legacy T-SQL error-handling functionality and the newer structured error-handling model in T-SQL. This chapter introduces tools useful for debugging server-side code, including T-SQL statements and the Visual Studio IDE.
I will also discuss dynamic SQL in this chapter, which is often more difficult to ...