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 11 of 11   

Terminating with THROW

By Sean Pearce 2014/10/21 | Category: throw
Rating: (not yet rated) |  Discuss |   Briefcase | 1,654 reads

THROW formatting

By Steve Jones 2014/10/10 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,553 reads

THROW defaults

By Steve Jones 2014/10/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,495 reads

Catch this!

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


By Venkat Jonnalagadda 2013/04/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,143 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,343 reads

Usage of @@ERROR in Transaction

By Raj 2012/11/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,269 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,462 reads

what does the second @@error return?

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

@@Error and sp_rename

By John Moreno 2009/09/03 | Category: error handling
Rating: (not yet rated) |  Discuss |   Briefcase | 3,377 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,943 reads
   Items 1 to 11 of 11   
throw (3)    
@@error (2)    
try..catch (2)    
isnull (1)    
logging (1)    
raiserror (1)