sql 存储过程创建事务

以银行ATM取款机系统为例usemastergoifexists(select1fromsysdatabaseswherenamelike'ATM')dropdatabaseATMgocreatedatabaseATMonprimary(name='ATM_data',filename='d:\sqltest\atm_data.mdf')logon(name='ATM_log',filename='d:\sqltest\atm_data.ldf')go