sql server 表分区

   CREATE PARTITION FUNCTION partCustomerStockHistory (datetime)

　　AS RANGE RIGHT FOR VALUES ('20160101','20170101','20180101','20180630','20190101','20190630','20200101')

 CREATE PARTITION SCHEME partschCustomerStockHistory

　　AS PARTITION partCustomerStockHistory

　　TO ( h2016,  h2017, h201801, h201806, h201901, h201906, h202001, h202006)

CREATE TABLE CustomerStockHistoryOfK(
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [CustomerLegalId] [int] NOT NULL,
    [ProductId] [int] NOT NULL,
    ON partschCustomerStockHistory([CreatedOn])