如何使用T-SQL向SQL Server添加多个文件并再添加一列

CREATE DATABASE YourDatabase
ON PRIMARY
(
    NAME = YourDatabase_Data,
    FILENAME = 'C:\YourDatabase_Data.mdf',
    SIZE = 100MB,
    MAXSIZE = UNLIMITED,
    FILEGROWTH = 10MB
)
LOG ON
(
    NAME = YourDatabase_Log,
    FILENAME = 'C:\YourDatabase_Log.ldf',
    SIZE = 50MB,
    MAXSIZE = 2GB,
    FILEGROWTH = 5MB
)

ALTER DATABASE YourDatabase
ADD FILEGROUP YourFileGroup1

ALTER DATABASE YourDatabase
ADD FILE
(
    NAME = YourFile1,
    FILENAME = 'C:\YourFile1.ndf',
    SIZE = 200MB,
    MAXSIZE = UNLIMITED,
    FILEGROWTH = 20MB
)
TO FILEGROUP YourFileGroup1

ALTER DATABASE YourDatabase
ADD FILEGROUP YourFileGroup2

ALTER DATABASE YourDatabase
ADD FILE
(
    NAME = YourFile2,
    FILENAME = 'C:\YourFile2.ndf',
    SIZE = 300MB,
    MAXSIZE = UNLIMITED,
    FILEGROWTH = 30MB
)
TO FILEGROUP YourFileGroup2

ALTER TABLE YourTable
ADD YourColumn INT