,NET自己做项目的源代码购物网站

create proc selectduct AS select * from Product go execute selectduct go create proc Bdds @a int AS insert into shopping(Pid) values(@a) go exec Bdds create proc jilu AS select s.id,p.title,p.price,s.number,s.sptime from product p,shopping s where s.pid=p.id go exec jilu create proc jilu2 AS select pid,uid,title,count(number) ,sum(price) from (select s.pid,s.uid,p.title,p.price,s.number,s.sptime from product p,shopping s where s.pid=p.id)as newhso group by title,pid,uid order by pid go exec jilu2 create proc jilu3 As select sum(s.number) 商品总件数,sum(p.price) 需要支付 from product p,shopping s where p.id=s.pid go exec jilu3