付録F.14 「AlterPartition2nd.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0001]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20120101​')
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0002]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20120201​')
GO

ALTER PARTITION SCHEME netmdm_monitoring_security_ps NEXT USED [netmdm_moni_dp_0003]
GO

ALTER PARTITION FUNCTION netmdm_monitoring_security_pf() SPLIT RANGE ('20120301​')
GO