CreatePartition.sql query script

USE [NETMDM_SAMPLE]
GO
 
CREATE PARTITION FUNCTION netmdm_monitoring_security_pf (datetime) AS RANGE RIGHT FOR VALUES (
        '20110101',
        '20110201',
        '20110301',
        '20110401',
        '20110501',
        '20110601',
        '20110701',
        '20110801'
)
GO
 
CREATE PARTITION SCHEME netmdm_monitoring_security_ps AS PARTITION netmdm_monitoring_security_pf TO (
        [netmdm_moni_seg],
        [netmdm_moni_dp_0001],
        [netmdm_moni_dp_0002],
        [netmdm_moni_dp_0003],
        [netmdm_moni_dp_0004],
        [netmdm_moni_dp_0005],
        [netmdm_moni_dp_0006],
        [netmdm_moni_dp_0007],
        [netmdm_moni_dp_0008]
)
GO

All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.

Appendix F.5 CreatePartition.sql query script