select_book_name.sql

来自「图书馆系统建立」· SQL 代码 · 共 8 行

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