createebdb.sql

学生用银行数据库及部分银行数据库中的部分数据

/*      Install EarnestBank database             */

set nocount    on
USE master
declare @dttm varchar(55)
select  @dttm=convert(varchar,getdate(),113)
raiserror('Starting installation of EarnestBank Database at %s ....',1,1,@dttm) with nowait
--set dateformat mdy
GO
--sp_addlogin user1,null,EarnestBank
if exists (select * from sysdatabases where name='EarnestBank')
begin
  raiserror('Dropping existing EarnestBank database ....',0,1)
  DROP database EarnestBank
end
GO

CHECKPOINT
go

raiserror('Creating EarnestBank database....',0,1)
go

   create DATABASE EarnestBank
GO

CHECKPOINT

GO

USE EarnestBank

GO

if db_name() <> 'EarnestBank'
   raiserror('Error in installEarnestBank.SQL, "USE EarnestBank" failed!  Killing the SPID now.'
            ,22,127) with log

GO

execute sp_dboption 'EarnestBank','trunc. log on chkpt.' ,'true'
checkpoint