page 230 to page 266.txt

Sql statement it is very cute

AssetNo,AssetName,SerialNo,Cost,PurchaseDate,Condition,LastCheck
1,"Photocopier","S987-123-11",12000,4/3/1999,"Good",9/9/2001
2,"IBM Computer","1234-5678",8000,6/2/2000,"Excellent",10/10/2001
3,"Fax Machine","8888-2222",3200,5/14/2001,"Require Replacement",11/10/2001
4,"Notebook computer","3F43614ABC",18000,12/13/1999,"Fair",10/10/2001


USE Sample
CREATE TABLE Equipment (
	AssetNo 	int 		NOT NULL	PRIMARY KEY,
	AssetName	char(30)	NOT NULL,
	SerialNo	char(30)	NOT NULL,
	Cost		money		NOT NULL,
	PurchaseDate	datetime	NOT NULL)
CREATE TABLE Maintenance (
	AssetNo		int		NOT NULL	PRIMARY KEY,
	Condition	char(10)	NOT NULL,
	LastCheck	datetime	NOT NULL)


TRUNCATE TABLE Equipment
TRUNCATE TABLE Maintenance
SELECT * FROM Equipment
SELECT * FROM Maintenance


SELECT * FROM Equipment
SELECT * FROM Maintenance


TRUNCATE TABLE Equipment
DROP TABLE Maintenance


SELECT * FROM Equipment


TRUNCATE TABLE Equipment
SELECT * FROM Equipment


TRUNCATE TABLE NW_Products
SELECT * FROM NW_Products


SELECT * FROM NW_Products