Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error handling & use of BEGIN TRY ...BEGIN CATCH

Status
Not open for further replies.
arrowhouse

arrowhouse

MIS
Sep 5, 2001
136
GB
Hi,

I've just started using SQL2005 & I see that there is now a set of statements:

BEGIN TRY
...
END TRY
BEGIN CATCH
...
END CATCH

Has anybody got any tips/experience on the best way to use this?

I'm calling one procedure from inside another one & I want to get the transaction contol correct & I'm not sure how the two interact.

Did look for a FAQ but couldn't find one.


Thanks.

 
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
590
grnzbra
grnzbra
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
855
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
908
BobSuruncle
BobSuruncle
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
369
Virendra Yaduvanshi
Virendra Yaduvanshi

Part and Inventory Search

Sponsor

Back
Top