一个事物(transaction)的超级简单的问题
我之前有一个store procedure交addItemToOrder,里面定义了三个变量@orderID, @itemID @requestcount,现在我想用事物来运行这个store procedure
我这样写的
BEGIN TRAN
UPDATE addItemToOrder
set @orderID =3, @itemID=1, @requestcount =1
set @orderID=3, @itemID=1, @requestcount=1
set @orderID=4, @itemID=1, @requestcount=1
set @orderID=3, @itemID=1, @requestcount=-1
set @orderID=1, @itemID=1, @requestcount=1
COMMIT TRAN
为啥提示各种错误呢?不对么?