createdb.sql

来自「本系统是结合行业管理中实际的人力资源、工资制度」· SQL 代码 · 共 15 行

CREATE DATABASE PERSONNEL_SYS
ON (
NAME = PERSONNEL_INFO,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\data\PERSONNEL_INFO.MDF',
SIZE = 10MB,
MAXSIZE = 50MB,
FILEGROWTH = 10MB
)
LOG ON(
NAME = PERSONNEL_LOG,
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\data\PERSONNEL_LOG.LDF',
SIZE = 10MB,
MAXSIZE = 20MB,
FILEGROWTH = 5MB
)