基于ASP网上书店系统 -

CREATE TABLE Books ( Id Int IDENTITY (1, 1), Typeid Int, BookName Varchar (200), ISBN Varchar (50), Publisher Varchar (100), Author Varchar (50), PageNum int, PublishDate datetime, SalePrice Float DEFAULT 0, StorePrice Float DEFAULT 0, Content Varchar (1000), ReadCount Int DEFAULT 0, BuyCount Int DEFAULT 0, ImageFile Varchar (50) ) GO