Listing 1: Creating Partitioned and Nonpartitioned Tables

USE master;
GO
IF EXISTS(SELECT * FROM
  sys.databases WHERE name='test')  
    DROP DATABASE test;
GO
CREATE DATABASE test;
GO
USE test;
GO
CREATE PARTITION function PF1 (int)
  AS RANGE LEFT FOR
    VALUES (1,2,3,4);
CREATE PARTITION SCHEME PS1 AS
  PARTITION PF1 ALL TO ([PRIMARY]);
CREATE TABLE test1 (a int, b int ,
  c char(100)) ON PS1 (a);
CREATE TABLE test2 (a int, b int ,
  c char(100))

-- Populate the tables with 1000
-- random rows
DECLARE @i int; SET NOCOUNT ON;
  SET @i=0;
WHILE @i<1000
BEGIN SET @i=@i+1; INSERT INTO
  test1 VALUES (5*rand(),
    100*rand(), ' ') END;
INSERT INTO test2 SELECT * FROM
  test1
GO