Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: MSSQL 2005 BEGIN TRANSACTION (SQL)
Title: MSSQL 2005 BEGIN TRANSACTION Language: SQL
Description: BEGIN TRY BEGIN TRANSACTION Views: 1089
Author: Gene Berger Date Added: 3/15/2008
Copy Code   
BEGIN TRY
   BEGIN TRANSACTION

   COMMIT
END TRY
BEGIN CATCH
  -- Whoops, there was an error
  IF @@TRANCOUNT > 0
     ROLLBACK

  -- Raise an error with the details of the exception
  DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
  SELECT @ErrMsg = ERROR_MESSAGE(),
         @ErrSeverity = ERROR_SEVERITY(), 
         @p_io_Is_Error = @@error

  RAISERROR(@ErrMsg, @ErrSeverity, 1)
END CATCH
Usage 
BEGIN TRY
   BEGIN TRANSACTION
Notes
BEGIN TRY BEGIN TRANSACTION