hrsys.sql

来自「vb+sql 的企业人事管理系统 c/s模式 适合初学者使用」· SQL 代码 · 共 32 行

USE master
GO
CREATE DATABASE HrSys 
ON
PRIMARY ( NAME = Hr1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData1.mdf',
      SIZE = 100MB,
      MAXSIZE = 200,
      FILEGROWTH = 20),
( NAME = Hr2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData2.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = Hr3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData3.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
LOG ON 
( NAME = HrLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog1.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = HrLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog2.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
GO