ALTER PROCEDURE dbo.search_result_cominfo @add_city int,@com_name varchar(50)
AS
SELECT userid, user_company, user_realname, user_tel, user_mobi, user_fax FROM User_Table
WHERE (user_city = @add_city) AND (user_company LIKE '%@com_name%')
RETURN怎么都搜索不到东西,数据库有符合条件的记录呀。请大家帮我看看怎么回事!
AS
SELECT userid, user_company, user_realname, user_tel, user_mobi, user_fax FROM User_Table
WHERE (user_city = @add_city) AND (user_company LIKE '%@com_name%')
RETURN怎么都搜索不到东西,数据库有符合条件的记录呀。请大家帮我看看怎么回事!
转换成字符串
改成
like '%' + @com_name+'%'
不是显示0条回复么
咋一提交就有这么多人到我前面了。
==>表示一个字符串.就是'张三' 一样
AS
SELECT userid, user_company, user_realname, user_tel, user_mobi, user_fax FROM User_Table
WHERE (user_city = @add_city) AND (user_company LIKE '%' + @com_name+'%')
RETURN
就可以了 因为'%@com_name%'会被错误的当成一整个字符串
先就这样吧。谢谢大家!再次特别感谢cpp2017(慕白兄) !