demo029.sql

T-SQL示例大全

/* 文件名称: Demo029.sql */
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'TestDB')
	DROP DATABASE TestDB
GO

CREATE DATABASE TestDB  ON (NAME = N'TestDB_Data', FILENAME = N'C:\Temp\TestDB_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'TestDB_Log', FILENAME = N'C:\Temp\TestDB_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE Chinese_Taiwan_Stroke_CI_AS
GO
ALTER DATABASE TestDB ADD FILEGROUP UdfGroup 
GO
ALTER DATABASE TestDB ADD FILE(NAME = N'TestDB1', FILENAME = N'C:\Temp\TestDB1_Data.NDF' , SIZE = 1, FILEGROWTH = 10%) TO FILEGROUP UdfGroup
GO
ALTER DATABASE TestDB ADD FILE(NAME = N'TestDB2', FILENAME = N'C:\Temp\TestDB2_Data.NDF' , SIZE = 1, FILEGROWTH = 10%) TO FILEGROUP UdfGroup
GO
ALTER DATABASE TestDB ADD FILE(NAME = N'TestDB3', FILENAME = N'C:\Temp\TestDB3_Data.NDF' , SIZE = 1, FILEGROWTH = 10%) TO FILEGROUP UdfGroup
GO

ALTER DATABASE TestDB MODIFY FILEGROUP UdfGroup DEFAULT
GO

USE testDB

SELECT * INTO test FROM 北风贸易.dbo.飞狐工作室
GO

--DBCC SHRINKFILE (TestDB2, EMPTYFILE)