SQL normal table to partitioned table

Copy codeThe Code is as follows: create table Sale (
[Id] [int] identity () not null, -- Automatic Growth
[Name] [varchar] (16) not null,
[SaleTime] [datetime] not null,
Constraint [PK_Sale] primary key clustered -- create a primary key
(
[Id] ASC
)
)
-- Insert some records
Insert Sale ([Name], [SaleTime]) values ('zhang san', '2014-1-1 ')
Insert Sale ([Name], [SaleTime]) values ('Li si', '2017-2-1 ')
Insert Sale ([Name], [SaleTime]) values ('wang wu', '2017-3-1 ')
Insert Sale ([Name], [SaleTime]) values ('money 6', '2017-4-1 ')
Insert Sale ([Name], [SaleTime]) values ('zhao qy', '2017-5-1 ')
Insert Sale ([Name], [SaleTime]) values ('zhang san', '2017-6-1 ')
Insert Sale ([Name], [SaleTime]) values ('Lee 4', '2017-7-1 ')
Insert Sale ([Name], [SaleTime]) values ('wang wu', '2017-8-1 ')
Insert Sale ([Name], [SaleTime]) values ('money 6', '2017-9-1 ')
Insert Sale ([Name], [SaleTime]) values ('zhao qy', '2017-10-1 ')
Insert Sale ([Name], [SaleTime]) values ('zhang san', '2017-11-1 ')
Insert Sale ([Name], [SaleTime]) values ('Lee 4', '2017-12-1 ')
Insert Sale ([Name], [SaleTime]) values ('wang wu', '2017-12-1 ')

Alter table Sale drop constraint PK_Sale
-- Create a primary key, but not a clustered Index
Alter TABLE Sale add constraint PK_Sale primary key nonclustered
(
[ID] ASC
) ON [PRIMARY]

-- Create a partition function
GO
Create partition function [pf_Sale] (SaleTime) as range left for values (n'1996-5-1T00: 00: 000000', n' 2010-9-1T00: 00: 100'
GO

-- Create a partition structure
GO
Create partition scheme [pt_Sale] as partition [pf_Sale] TO ([Sale1], [Sale3], [Sale2])
GO

-- Create a [pt_Sale] Architecture
GO
Create table [dbo]. [AvCache] (
[Id] [int] identity () not null, -- Automatic Growth
[Name] [varchar] (16) not null,
[SaleTime] [datetime] not null,
) On [pt_Sale] (SaleTime) -- Note that the [pt_Sale] architecture is used here, which is partitioned according to SaleTime

-- View usage
SELECT *, $ PARTITION. [pt_Sale] (SaleTime)
FROM dbo. [AvCache]