存储过程.txt

SQL Sever2000,THEN COURSE DESIGN OF DATABASE SYSTEM PANORAMA

存储过程，查看某天销售了哪些书，各销售了多少本,每种书的销售总价。
CREATE PROC  DateSales  @date  datetime
  as
    select OrderDate ,OrderDetails.BookID, Books.BookName,Quantity , Books.UnitPrice*Quantity as totalprice
       from  OrderDetails ,Orders,Books
         where OrderDetails.OrderID=Orders.OrderID
              and OrderDetails.BookID =Books.BookID
             and Orders.OrderDate=@date
GO


输入一本书的书名来查询它的销售信息
Create  proc book_sale  @book_name varchar(20)
as	
select BookID as 书籍编号,BookName as 书籍名称，BookSale as 销售量
  from Books
  where BookName=@book_name
go