Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: SQL Transaction (SQL)
Title: SQL Transaction Language: SQL
Description: Simple SQL Transaction Views: 366
Author: Tim Wilson Date Added: 10/31/2007
Copy Code   
BEGIN TRAN

    -- DO SOMETHING

    IF (@@ERROR <> 0) GOTO ERR_HANDLER

    -- DO SOMETHING ELSE

    IF (@@ERROR <> 0) GOTO ERR_HANDLER

COMMIT TRAN

RETURN 0

ERR_HANDLER:
PRINT 'Unexpected error occurred!'
ROLLBACK TRAN
RAISERROR('Something bad happened.', 16, 1)

 -- or you can 
 -- RETURN 1
Usage 
Retrieve return value:

If parameters.Find("RETURN_VALUE").Value = 1 Then