select_book_author.sql

图书馆系统建立

CREATE PROCEDURE  Select_book_author
(@book_author char)
 AS
SELECT book_id,book_name,book_pub,book_price,book_author,book_intr,
book_address,type_contain,book_state_contain FROM [book_info],[type],[book_state] WHERE  book_author=@book_author 
AND [book_info].[type_id]=[type].[type_id] AND [book_info].[book_state_id]=[book_state].[book_state_id]
GO