sqlquery1.sql

来自「完成一个网上书店系统」· SQL 代码 · 共 14 行

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