资源描述：
《银行atm存取款机系统数据库设计》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、银行ATM存取款机系统数据库设计execsp_configure'showadvancedoption',1goreconfiguregoexecsp_configure'xp_cmdshell',no_ouputgoreconfiguregoexecxp_cmdshell'mkdirG:SQL银行ATM存取款机系统数据库设计'goifexists(select*fromsysdatabaseswherename='ATMBankDataBase')dropdatabaseATMBankDataBasegocreatedat
2、abaseATMBankDataBaseon(name='ATMBankDataBase_Data',filename='G:SQL银行ATM存取款机系统数据库设计ATMBankDataBase_Data.mdf',size=5mb,filegrowth=30%)logon(name='ATMBankDataBase_Log',filename='G:SQL银行ATM存取款机系统数据库设计ATMBankDataBase_Log.ldf',size=5mb,filegrowth=30%)go-------------
3、------------创建数据表-------------------------useATMBankDataBasegoifexists(select*fromsysobjectswherename='ATM_AccountInfo')droptableATM_AccountInfogocreatetableATM_AccountInfo(CarIDvarchar(20)notnull,PassWordchar(10)notnull,TypeIDintnotnull,DF_TypeIDintnotnull,OpenAccoun
4、tDatedatetimenotnull,OpenAccountMoneydecimal(18,2)notnullDropIDintnotnull)goselect*fromATM_AccountInfoifexists(select*fromsysobjectswherename='ATM_DealInfo')droptableATM_DealInfogocreatetableATM_DealInfo(CardIDvarchar(20)notnull,DealDatedatetimenotnull,DealMoneydecima
5、l(18,2)notnull,DealTypeIDintnotnull,Copyvarchar(50)notnull)goselect*fromATM_DealInfoifexists(select*fromsysobjectswherename='ATM_DepositFatchType')droptableATM_DepositFatchTypegocreatetableATM_DepositFatchType(DF_TypeIDintidentity(1,1)notnull,DF_Namevarchar(20)notnull
6、)goselect*fromATM_DepositFatchTypeifexists(select*fromsysobjectswherename='ATM_AccountType')droptableAccountTypegocreatetableATM_AccountType(DropIDintidentity(1,1)notnull,CardStatevarchar(10)notnull)goselect*fromATM_AccountTypeifexists(select*fromsysobjectswherename='
7、ATM_DealType')droptableATM_DealTypegocreatetableATM_DealType(DealTypeIDintidentity(1,1)notnull,DealNamevarchar(10)notnull)goselect*fromATM_DealTypeifexists(select*fromsysobjectswherename='ATM_CurrencyType')droptableATM_CurrencyTypegocreatetableATM_CurrencyType(TypeIDi
8、ntidentity(1,1)notnull,TypeNamevarchar(10)notnull)goselect*fromATM_CurrencyTypeifexists(select*fromsysobjectswherename='ATM_
