User_Id_2],[FG_User_Id_3])
--Ext2
CREATE PARTITION SCHEME
Sch_User_Id AS
PARTITION Fun_User_Id
TO([FG_User_Id_1],[FG_User_Id_2],[PRIMARY])
步骤5：为MyDataBase数据库创建一个名为User的表，这个表有3个字段，Id是自增标识，并在Id字段中创建聚集索引，填充因子为100%，使用上面创建的Sch_User_Id分区方案，创建有不同的创建方式，如Ext1、Ext2、Ext3；
--5.创建表
--Ext1
CREATE TABLE [dbo].[User](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](256) COLLATE Chinese_PRC_CI_AS NULL,
[Age] [int] NULL CONSTRAINT [DF_User_Age] DEFAULT ((0)),
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH( PAD_INDEX = ON, FILLFACTOR = 100, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Sch_User_Id](Id)
) ON [Sch_User_Id]([Id])
--Ext2
CREATE TABLE [dbo].[User](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](256) COLLATE Chinese_PRC_CI_AS NULL,
[Age] [int] NULL CONSTRAINT [DF_User_Age] DEFAULT ((0)),
) ON [Sch_User_Id]([Id])
GO
CREATE CLUSTERED INDEX [IX_User_Id] ON dbo.[User]
(
[Id]
) WITH( PAD_INDEX = ON, FILLFACTOR = 100, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Sch_User_Id](Id)
GO
--Ext3
ALTER TABLE dbo.[User] ADD CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
Id
) WITH( PAD_INDEX = ON, FILLFACTOR = 100, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Sch_User_Id](Id)
GO
步骤6：为User表创建测试数据，这里我就模拟从一个存在的OldUser表中导入数据到分区User表，这里需要注意SET IDENTITY_INSERT 表ON 这个选项；
--6.导入数据
SET IDENTITY_INSERT 表ON
INSERT INTO dbo.表
( [Id]
,[UserName]
,[Age])
SELECT
[Id]
,[UserName]
,[Age]
FROM dbo.[OldUser](nolock) WHERE 条件
SET IDENTITY_INSERT 表OFF
--Ext
SET IDENTITY_INSERT [User] ON
INSERT INTO dbo.[User]
( [Id]
,[UserName]
,[Age])
SELECT
&nb
|