createdbbase.txt

来自「天涯進銷存系統」· 文本 代码 · 共 17 行

CREATE PROC dbo.sp_tianyacreatedb  /*新建套帐*/
  @database char(20),
  @dbname   char(20),   
  @dbfile   char(100),   
  @dblog   char(20),   
  @dblogfile   char(100)   
  as   
  exec('   
  use   master   
  create   database   '+@database+'   
  on     
  (   name   =   '+@dbname+',   
      filename   =   '''+@dbfile+''')   
  log   on   
  (   name   =   '+@dblog+',   
    filename   =   '''+@dblogfile+''')   
  ')