8-40.sql

sql2000工程实践一书第8张源代码

USE master
GO
ALTER DATABASE College 
ADD FILE 
(
 NAME = college_Data1,
 FILENAME = 'C:\college\college_Data1.ndf',
 SIZE = 5MB,
 MAXSIZE = 100MB,
 FILEGROWTH = 5MB
)
GO