付録F.21 「LargeSwitchPartition.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 1 TO netmdm_monitoring_security_arch PARTITION 1
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 2 TO netmdm_monitoring_security_arch PARTITION 2
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 3 TO netmdm_monitoring_security_arch PARTITION 3
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 4 TO netmdm_monitoring_security_arch PARTITION 4
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 5 TO netmdm_monitoring_security_arch PARTITION 5
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 6 TO netmdm_monitoring_security_arch PARTITION 6
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 7 TO netmdm_monitoring_security_arch PARTITION 7
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 8 TO netmdm_monitoring_security_arch PARTITION 8
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 9 TO netmdm_monitoring_security_arch PARTITION 9
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 10 TO netmdm_monitoring_security_arch PARTITION 10
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 11 TO netmdm_monitoring_security_arch PARTITION 11
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 12 TO netmdm_monitoring_security_arch PARTITION 12
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 13 TO netmdm_monitoring_security_arch PARTITION 13
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 14 TO netmdm_monitoring_security_arch PARTITION 14
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 15 TO netmdm_monitoring_security_arch PARTITION 15
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 16 TO netmdm_monitoring_security_arch PARTITION 16
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 17 TO netmdm_monitoring_security_arch PARTITION 17
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 18 TO netmdm_monitoring_security_arch PARTITION 18
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 19 TO netmdm_monitoring_security_arch PARTITION 19
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 20 TO netmdm_monitoring_security_arch PARTITION 20
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 21 TO netmdm_monitoring_security_arch PARTITION 21
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 22 TO netmdm_monitoring_security_arch PARTITION 22
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 23 TO netmdm_monitoring_security_arch PARTITION 23
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 24 TO netmdm_monitoring_security_arch PARTITION 24
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 25 TO netmdm_monitoring_security_arch PARTITION 25
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 26 TO netmdm_monitoring_security_arch PARTITION 26
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 27 TO netmdm_monitoring_security_arch PARTITION 27
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 28 TO netmdm_monitoring_security_arch PARTITION 28
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 29 TO netmdm_monitoring_security_arch PARTITION 29
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 30 TO netmdm_monitoring_security_arch PARTITION 30
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 31 TO netmdm_monitoring_security_arch PARTITION 31
GO

ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 32 TO netmdm_monitoring_security_arch PARTITION 32
GO