异常信息输出
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