CREATE TABLE cardInfo --银行卡信息表 ( cardID CHAR(19) NOT NULL, curType CHAR(5) NOT NULL, savingType CHAR(8) NOT NULL, openDate DATETIME NOT NULL, openMoney MONEY NOT NULL, balance MONEY NOT NULL, pass CHAR(6) NOT NULL, IsReportLoss BIT NOT NULL, custome
网上找的觉得挺有用的银行ATM存取款机系统 print '开始转账，请稍后......' print '交易正在进行，请稍后......' update Cardinfo set balance=balance-@money where customerID=(select customerID from UserInfo where customerName='张三') print '交易成功！交易金额：'+convert(varchar(20),@money) select @carod1
