SQL Try Catch

BEGIN TRY

BEGIN TRANSACTION;

-- delete/insert statement here

COMMIT TRANSACTION;

END TRY

BEGIN CATCH

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();

RAISERROR(@ErrMsg, @ErrSeverity, 1);

END CATCH;