第六章解答题

BEGIN TRANSACTION  
DECLARE @errorSum int  
DECLARE @RID varchar(50)  
DECLARE @BID varchar(50)  
SELECT @RID=RID FROM Reader WHERE RName='张无忌'  
SELECT @BID=BID FROM Book WHERE BName='深入。Net平台和c#编程'  
SET @errorSum=0  
INSERT INTO Borrow(RID,BID)VALUES (@RID,@BID)  
SET @errorSum=@errorSum+@@error  
UPDATE Book SET BCount=BCount-1 WHERE BName=' 深入。Net平台和c#编程'  
SET @errorSum=@errorSum+@@error  
UPDATE Reader SET LendNum=LendNum+1 WHERE RName='张无忌'  
SET @errorSum=@errorSum+@@error  
IF @errorSum<>0  
        ROLLBACK TRANSACTION  
    ELSE   
    COMMIT TRANSACTION  
GO  

[sql] view plain copy 在CODE上查看代码片派生到我的代码片
/*  
*事务操作借书  
*/  
BEGIN TRANSACTION  
  
  
DECLARE @errorSum int  
DECLARE @RID varchar(50)  
DECLARE @BID varchar(50)  
SELECT @RID=RID FROM Reader WHERE RName='刘冰冰'  
SELECT @BID=BID FROM Book WHERE BName='西游记'  
SET @errorSum=0  
INSERT INTO Penalty(RID,BID,PType,Amount) VALUES(@RID,@BID,'1',5.6)  
SET @errorSum=@errorSum+@@error  
UPDATE Borrow SET ReturnDate=getdate() WHERE BID=@BID  
SET @errorSum=@errorSum+@@error  
UPDATE Reader SET LendNum=LendNum-1 WHERE RName='刘冰冰'  
SET @errorSum=@errorSum+@@error  
UPDATE Book SET BCount=BCount+1 WHERE BID=@BID  
SET @errorSum=@errorSum+@@error  
IF @errorSum<>0  
        ROLLBACK TRANSACTION  
    ELSE   
    COMMIT TRANSACTION  
GO