控制事务处理
BEGIN TRANSACTION ... COMMIT TRANSACTION
使用ROLLBACK
DELETE FROM Orders ROLLBACK;
使用保留点
SAVEPOINT delete1; ROLLBACK TO delete1;
BEGIN TRANSACTION ... COMMIT TRANSACTION
DELETE FROM Orders ROLLBACK;
SAVEPOINT delete1; ROLLBACK TO delete1;
转载于:https://www.cnblogs.com/xjyxp/p/11162815.html