JP1/NETM/DM 構築ガイド (Windows(R)用)

[目次][用語][索引][前へ][次へ]

付録F.5　「CreatePartition.sql」クエリスクリプト

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.