ASP.NET网络书城

select * from homecar delete homecar select * from homebooks drop table homebooks create table homebooks ( bid int identity(1,1)primary key, bname nvarchar(29)not null, bauthor nvarchar(30), bpub nvarchar(50)not null, btime nvarchar(20)not null, bprice nvarchar(29)not null, bimg nvarchar(59)not null, bleeve varchar(2)not null, btype nvarchar(29)not null, btypec nvarchar(29)not null ) insert homebooks values('JAVA','邮电出版社','2009-02-21','32','book_img/1.jpg','5','特别推荐','特别推荐1') insert homebooks values('中国发展史','邮电出版社','2009-02-21','32','book_img/1.jpg','5','特别推荐','特别推荐2') insert homebooks values('销售的小技巧','邮电出版社','2009-02-21','32','book_img/1.jpg','5','特别推荐','特别推荐3') insert homebooks values('伟人','邮电出版社','2009-02-21','32','book_img/1.jpg','5','特别推荐','特别推荐4') insert homebooks values('sd4aafa','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐1') insert homebooks values('sd4aafsd','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐2') insert homebooks values('sd4aafd','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐3') insert homebooks values('sd4aafads','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐4') insert homebooks values('sd4aaf1','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐5') insert homebooks values('sd4aaf2','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐6') insert homebooks values('sd4aaf3','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐7') insert homebooks values('sd4aaf4','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐8') insert homebooks values('sd4aaf5','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐9') insert homebooks values('sd4aaf6','人民出版商','2010-10-03','34','book_img/1.jpg','4','本周推荐','本周推荐10') insert homebooks values('sd4fa','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐1') insert homebooks values('sd4f12','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐2') insert homebooks values('sd4f23','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐3') insert homebooks values('sd4f33','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐4') insert homebooks values('sd4f11','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐5') insert homebooks values('sd4f41','新疆出版','2005-12-12','10','book_img/1.jpg','4','图书推荐','图书推荐6') insert homebooks values('sd4f32','人民出版社','2008-01-29','10','book_img/1.jpg','5','专题推荐','专题推荐1') insert homebooks values('sd4f221','人民出版社','2008-01-29','10','book_img/1.jpg','5','专题推荐','专题推荐2') insert homebooks values('sd4f333','人民出版社','2008-01-29','10','book_img/1.jpg','5','专题推荐','专题推荐3') insert homebooks values('sd4f123','人民出版社','2008-01-29','10','book_img/1.jpg','5','专题推荐','专题推荐4') delete homebooks select * from homebooks