--=============================================
--Createdatabaseonmulitplefilegroups
--=============================================
IFEXISTS(SELECT*
FROM master..sysdatabases
WHERE name=N'')
DROPDATABASE
GO
CREATEDATABASE
ONPRIMARY
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%),
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%),
FILEGROUP
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%),
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%),
FILEGROUP
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%)
LOGON
(NAME=,
FILENAME=N'',
SIZE=1MB,
MAXSIZE=200MB,
FILEGROWTH=10%)
GO
阅读(253) | 评论(0) | 转发(0) |