If you have study about the Introduction of Database before, then, you have to practice to make a table. This is the example of Rep Table. Write this syntax on your SQL 2000 Query Analyzer.
CREATE TABLE Rep(
RepNum INT NOT NULL UNIQUE,
LastName VARCHAR(25),
FirstName VARCHAR(25),
Street VARCHAR(30),
City VARCHAR(20),
State VARCHAR(2),
Zip VARCHAR(5),
Commision DECIMAL(10,2),
PRIMARY KEY (RepNum)
);
Continue Reading »