createdb.sql

来自「该章文件夹Chap1下存放的以下4个文件：CreateTable.txt、Cre」· 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
)