-
-
(求助)我学习SQL2000数据库一组创建数据库语句总提示错误??
-
发表于:
2005-11-3 16:54
5669
-
(求助)我学习SQL2000数据库一组创建数据库语句总提示错误??
create database stu2_class
on
primary(name=class1_data,
filename='c:\program files\microsoft sql server\mssql\data\class1.mdf',
size=20mb,
filegrowth=20%),
(name=class2,
filename='c:\program files\microsoft sql server\mssql\data\class2.ndf',
size=20mb,
maxsize=100,
filegrowth=10),
FILEGROUP CLASSGROUP
LOG ON
(name=classlog1,
filename='c:\program files\microsoft sql server\mssql\data\classlog1.ldf',
size=15mb,
maxsize=30,
filegrowth=2),
(name=classlog2,
filename='c:\program files\microsoft sql server\mssql\data\classlog2.ldf',
size=15mb,
maxsize=30mb,
filegrowth=2mb)
[注意]传递专业知识、拓宽行业人脉——看雪讲师团队等你加入!