SQL回滾Transaction來調試SQL語句
用事務回滾來調試SQL,可以避免錯誤操作對數據庫的影響.MARK.
CodeBEGIN TRANSACTION
SAVE TRANSACTION StartOrder;
-- here insert or delete data
--IF @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;
IF 1 <> 0 ROLLBACK TRANSACTION StartOrder;
COMMIT TRANSACTION
簡單點
Codebegin tran
-- here insert or delete data
rollback tran
浙公網安備 33010602011771號