📄 page 230 to page 266.txt
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -