BEGIN TRANSACTION TRAN1
BEGIN TRY
INSERT INTO.....
UPDATE.....
END TRY
BEGIN CATCH
If @@TRANCOUNT > 0
--error happened
ROLLBACK TRANSACTION TRAN1
END CATCH
If @@TRANCOUNT > 0
COMMIT TRANSACTION TRAN1
GO
Showing posts with label try catch block. Show all posts
Showing posts with label try catch block. Show all posts
Thursday, October 16, 2014
Subscribe to:
Posts (Atom)