bookdetail.sql

完成一个网上书店系统

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go
create proc BookDetail
(
@BookID int,
@BookMarketPrice money output,
@BookName varchar(50) output,
@BookImage varchar(50) output,
@BookPrice money output,
@BookInfo varchar(500) output,
@Writer nvarchar(15) output,
@Pree nvarchar(50) output,
@ISBN nvarchar(15) output
)
as
select 
@BookID=BookID,
@BookMarketPrice=BookMarketPrice,
@BookName=BookName,
@BookImage=BookImage,
@BookPrice=BookPrice,
@BookInfo=BookInfo,
@Writer=Writer,
@Pree=Pree,
@ISBN=ISBN
from Books
where BookID=@BookID