sql server try catch 事务回滚
2019-02-13 本文已影响0人
DH东海
BEGIN TRY
BEGIN TRAN
--操作语句
COMMIT TRAN;
END TRY
BEGIN CATCH
ROLLBACK TRAN;
END CATCH
BEGIN TRY
BEGIN TRAN
--操作语句
COMMIT TRAN;
END TRY
BEGIN CATCH
ROLLBACK TRAN;
END CATCH