Create Database DBBank
Go
Use DBBank
--创建tbl_accounts表
Create Table tbl_accounts
(
account_num varchar(10) primary key,
account_name varchar(50),
balance decimal(10,3),
memory varchar(200)
)
--往tbl_accounts表中插入数据
Insert Into tbl_accounts Values('A','东方软件',60000,null)
Insert Into tbl_accounts Values('B','东方软件',30000,null)
Insert Into tbl_accounts Values('C','新天贸易',100000,null)
Select * from tbl_accounts
--(1)使用显式事务,完成银行转账业务;
--开始定义事务
Begin Transaction T_transfer
Select * from tbl_accounts where account_num='A' And account_name='东方软件'
Update tbl_accounts set balance=balance-10000 where account_num='A' And account_name='东方软件'</