SQL Server Try Catch and transaction Example

BEGIN TRY

BEGIN TRANSACTION

 --Update or Insert statements

COMMIT TRANSACTION

END TRY

BEGIN CATCH

 select ERROR_NUMBER() as ErrorNumber, ERROR_LINE() as ErrorLine, ERROR_MESSAGE() as ErrorMessage

IF (XACT_STATE()) <> 0 

   BEGIN

     ROLLBACK TRANSACTION

   END

END CATCH