SQL Server Magazine

Listing 1: DDL Statement to Create Sales Table

SET NOCOUNT ON; 

USE tempdb; 



IF OBJECT_ID('dbo.Sales', 'U') IS NOT NULL DROP TABLE dbo.Sales; 



CREATE TABLE dbo.Sales

(

   empid INT         NOT NULL,          -- partitioning column

   dt         DATETIME NOT NULL,          -- ordering column

   qty         INT         NOT NULL DEFAULT (1),          -- measure 1

   val         MONEY	NOT NULL DEFAULT (1.00), -- measure 2

   CONSTRAINT PK_Sales PRIMARY KEY(empid, dt) 

); 

GO