Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, Error Handling Rss

   Items 1 to 8 of 8   

Catch this!

By Auke Teeninga 2014/04/10 | Category: isnull
Rating: (not yet rated) |  Discuss |   Briefcase | 2,051 reads


By Venkat Jonnalagadda 2013/04/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,136 reads

Re-throw Errors with Logging

This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.  Read more...
By Harsha Majety 2013/03/28 | Source: | Category: error handling
Rating: |  Discuss |   Briefcase | 5,304 reads

Usage of @@ERROR in Transaction

By Raj 2012/11/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,254 reads

ERROR_PROCEDURE Does Not Return a Schema Name

"A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now. SQL Server 2005 introduced the separation between user and schema. Though schemata already existed before SQL Server 2005, they really became usable with this version, imho. At the same time TRY...CATCH was a new way for structured error handling introduced. And so it finally became possible‚Ķ"  Read more...
By Additional Articles 2011/01/26 | Source: SQL Server Performance | Category: error handling
Rating: (not yet rated)  Rate this |   Briefcase | 2,447 reads

what does the second @@error return?

By wall str33t 2010/04/26 | Category: @@error
Rating: (not yet rated) |  Discuss |   Briefcase | 4,155 reads

@@Error and sp_rename

By John Moreno 2009/09/03 | Category: error handling
Rating: (not yet rated) |  Discuss |   Briefcase | 3,372 reads

Error Handling in Nested Procedures and Logging Custom Errors

Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.  Read more...
By Leo Peysakhovich 2008/07/07 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,933 reads
   Items 1 to 8 of 8   
@@error (2)    
try..catch (2)    
isnull (1)    
logging (1)    
raiserror (1)