addcart.sql

完成一个网上书店系统

insert into ShopCart( BookID,BookName,BookMarketPrice,BookPrice,ShopDate,BookCount)
select BookID,BookName,BookMarketPrice,BookPrice ,GETDATE(),0 from Books where BookID= 1

select * from ShopCart

alter proc addshopcart
(
@BookID int
)
as
update ShopCart

set BookCount=BookCount+1,MoneyCount=BookPrice*(BookCount+1),IsCanel='0'
where BookID=@BookID


exec addshopcart @BookID=1