SQL的LIKE模糊查询结果只有命令完成一句话,却无任何表格显示查询结果
相关代码如下:
ALTER PROCEDURE [dbo].[BOOK_frm_SearchBook](
@type char(100) = null,
@keywords char(30) = null,
@searchtype char(30) = null
)
AS
BEGIN
IF(@type = 'tab_QSearch')
BEGIN
IF(@searchtype = '图书名称')
BEGIN
SELECT
BOOK_Rec.BOOK_NAME As 图书名称,
BOOK_Rec.BOOK_NUM As 图书编码,
BOOK_Rec.BOOK_ISBN As 图书ISBN码,
BOOK_TYPE.BOOK_TYPE_NAME As 图书类型名称,
BOOK_Rec.BOOK_AUTHOR As 图书作者,
BOOK_Rec.BOOK_PRESS As 图书出版社,
BOOK_Rec.BOOK_PRESS_DATE As 图书出版日期,
BOOK_Rec.BOOK_PRICE As 图书价格,
BOOK_Rec.BOOK_PLACE As 图书存放位置,
BOOK_Rec.BOOK_MUCH As 图书库存数目,
BOOK_Rec.BOOK_FLAG_BORROW As 图书可借与否,
BOOK_Rec.BOOK_TEXT As 图书备注,
BOOK_INTRODUTION As 图书内容简介
FROM BOOK_Rec INNER JOIN
BOOK_TYPE ON BOOK_Rec.BOOK_TYPE_ID = BOOK_TYPE.BOOK_TYPE_ID
WHERE BOOK_Rec.BOOK_NAME LIKE '%[' +@keywords+ '%]'
END
END
END
执行该存储过程后只有提示:
命令成功完成,没有出现任何表格来显示查询结果.
请问该如何才能得到我查询后的结果?