数据库中查询时的‘回滚’的代码怎么写?
begin --取钱操作
BEGIN TRANSACTION
DECLARE @errorSum INT
SET @errorSum = 0
UPDATE cardInfo SET balance=balance-@blan1 WHERE cardID = @cardNo
SET @errorSum = @errorSum @@error
INSERT INTO transInfo (transDate,cardID,transType,transMoney,remark) VALUES (DEFAULT,@cardNo,@type,@blan1,'该用户 是要取钱')
SET @errorSum = @errorSum @@error
IF @errorSum<>0
BEGIN
PRINT '取钱失败'
ROLLBACK TRANSACTION --回滚
END
ELSE
BEGIN
print'取钱成功'
COMMIT TRANSACTION
END
end。