SQL Server 存储过程，事务、异常回滚处理机制(Begin try Begin Tran Begin Catch)

异常信息输出

SQL存储过程

CREATE PROCEDURE SP_Fin_Excu
	@FormID UNIQUEIDENTIFIER
AS
BEGIN
		BEGIN TRY
			BEGIN TRAN cal;
				print '';
			COMMIT TRAN cal;
		END TRY
		BEGIN CATCH
			ROLLBACK TRAN cal;
			--异常信息输出
		SELECT ERROR_NUMBER() AS error_number,ERROR_MESSAGE() AS error_message,ERROR_STATE() AS error_state, ERROR_SEVERITY() AS error_severity;
		END CATCH
END
GO