sql事务处理回滚及保留点transaction,ROLLBACK
1
BEGIN TRANSACTION
2INSERT INTO Customers(cust_id,cust_name)
3VALUES('100000010','Toys_Emporium');
4SAVE TRANSACTION StartOrder;
5INSERT INTO Orders(order_num,order_date,cust_id)
6VALUES(20100,'2001/12/1','100000010');
7IF @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;
8INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
9VALUES(20010,1,'BR01',100,5.49);
10if @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;
11INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
12VALUES(20010,2,'BR03',100,10.49);
13IF @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;
14COMMIT TRANSACTION
BEGIN TRANSACTION2
INSERT INTO Customers(cust_id,cust_name)3
VALUES('100000010','Toys_Emporium');4
SAVE TRANSACTION StartOrder;5
INSERT INTO Orders(order_num,order_date,cust_id)6
VALUES(20100,'2001/12/1','100000010');7
IF @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;8
INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)9
VALUES(20010,1,'BR01',100,5.49);10
if @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;11
INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)12
VALUES(20010,2,'BR03',100,10.49);13
IF @@ERROR <> 0 ROLLBACK TRANSACTION StartOrder;14
COMMIT TRANSACTION
