Advertisement

Error Handling and Dynamic SQL

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

Abstract

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 2012 still provides access to these tools, but it 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, we 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.

Keywords

Error Message Visual Studio 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jay Natarajan, Rudi Bruchez, Scott Shaw, and Michael Coles 2012

Authors and Affiliations

  • Jay Natarajan
  • Rudi Bruchez
  • Scott Shaw
  • Michael Coles

There are no affiliations available

Personalised recommendations