<pre class="brush: sql">/* This script creates a couple of table for use with 

** several examples in Chapter 3 of Beginning SQL Server ** 2008 Programming */

CREATE TABLE Stores ( StoreCode char(4) NOT NULL PRIMARY KEY, Name varchar(40) NOT NULL, Address varchar(40) NULL, City varchar(20) NOT NULL, State char(2) NOT NULL, Zip char(5) NOT NULL );

CREATE TABLE Sales ( OrderNumber varchar(20) NOT NULL PRIMARY KEY, StoreCode char(4) NOT NULL FOREIGN KEY REFERENCES Stores(StoreCode), OrderDate date NOT NULL, Quantity int NOT NULL, Terms varchar(12) NOT NULL, TitleID int NOT NULL );