sqlquery1.sql

完成一个网上书店系统

set ansi_nulls on
set quoted_identifier on
go


create procedure BookByCategory
(
	@CatID int
)
as
select BookID,BookName,BookImage,Writer,Pree,PreeTime,ISBN,BookMarketPrice,BookPrice
from Books
where CatID=@CatID
order by BookName,BookMarketPrice