SET XACT_ABORT ON //语句出错立即回滚,OFF为语句不出现严重错误时不会滚
BEGIN TRAN
BEGIN TRY
//SQL
END TRY
BEGIN CATCH
PRINT ERROR_MESSAGE()
END CATCH
COMMIT TRAN
SET XACT_ABORT ON //语句出错立即回滚,OFF为语句不出现严重错误时不会滚
BEGIN TRAN
BEGIN TRY
//SQL
END TRY
BEGIN CATCH
PRINT ERROR_MESSAGE()
END CATCH
COMMIT TRAN