Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Try Catch and other proc features

Author  Topic 

mrm23
Posting Yak Master

198 Posts

Posted - 2010-01-29 : 01:57:59
Hi,

Can someone explain how try catch block works? Also, How many try catch blocks can a proc have?
Can a try block have more than one catch?
Please help.

Thanks in advance.

Kristen
Test

22859 Posts

Posted - 2010-01-29 : 02:21:51
I suggest you start by reading the SQL documentation:

http://msdn.microsoft.com/en-us/library/ms175976.aspx
Go to Top of Page
   

- Advertisement -