select_book_name.sql

图书馆系统建立

CREATE PROCEDURE  Select_book_name 
(@book_name 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_name=@book_name
AND [book_info].[type_id]=[type].[type_id] AND [book_info].[book_state_id]=[book_state].[book_state_id]
GO