案例9模拟银行自动存取款.docVIP

案例9 模拟银行自动存取款 create database test go use test go --创建银行帐户表 create table bank (c_id int primary key identity, c_name varchar(10), bankroll money check(bankroll0) ) go -- 创建银行交易表 create table transinfo (transdate datetime default getdate(), transtype char(4) check (transtype in (存入,支取)), c_id int foreign key references bank(c_id), transmoney money ) go --向bank表中插入数据 insert into bank values(熊大,10000) insert into bank values(熊二,10000) select * from bank go --模拟自动存款业务（熊大存款） begin transaction declare @sum int --交易信息插入 insert into transinfo (transtype,c_id,transmoney) values (存入,1,8000)