1.SQL捕获异常
BEGIN TRY
BEGIN TRAN
/*脚本*/
COMMIT
END TRY
BEGIN CATCH
/*查看报错信息*/
SELECT
ERROR_NUMBER () AS error_number ,
ERROR_MESSAGE() AS error_message,
ERROR_STATE() AS error_state,
ERROR_SEVERITY() AS error_severity
ROLLBACK
END CATCH
Processed:
0.012, SQL:
9
