sql server new users: Error handling -- sql server new users

Error handling

Ramakant
3/30/2005 10:31:31 AM

sql server new users: hi,
I am sort of new at this...is there a way of handling errors using
try..catch in sql server? I know of @@error and @@rowCount but is there an
option for try-catch kind of stuff?
thanks in advance.
Ramakant

Re: Error handling

Jacco Schalkwijk
3/30/2005 1:27:59 PM

There will be try..catch in SQL Server 2005 (due for release in the second
half of this year), but there isn't in SQL Server 2000.

The following 2 articles give an excellent overview of error handling in SQL
Server 2000:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html

--
Jacco Schalkwijk
SQL Server MVP

[quoted text, click to view]