添加文件分组
image.png
创建文件,并分配文件组
image.png
分区函数
CREATE PARTITION FUNCTION partCustomerStockHistory (datetime...RANGE RIGHT FOR VALUES ('20160101','20170101','20180101','20180630','20190101','20190630','20200101')
分区方案...partCustomerStockHistory
TO ( h2016, h2017, h201801, h201806, h201901, h201906, h202001, h202006)
建表...CustomerLegalId] [int] NOT NULL,
[ProductId] [int] NOT NULL,
ON partschCustomerStockHistory([CreatedOn])
我的博客即将搬运同步至腾讯云