Question

sql存储过程中，模糊查询的写法

ALTER PROCEDURE [dbo].[pro_Search_keys]
@keys nvarchar(max)
AS
BEGIN
SELECT*
FROM text_Text
where Title like %@keys%
END
这样写会出错，感觉是格式问题，应该怎么写like后面呢？
like "%@keys%"

附近有语法错误。

Answer 1

ALTER PROCEDURE [dbo].[pro_Search_keys]
@keys nvarchar(max)
AS
BEGIN
SELECT*
FROM text_Text
where Title like ‘%’+@keys+‘%’
END

Answer 2

我对这种语法不是很清楚(我用oracle)
不过根据我的经验, 存储过程里不能有这种单纯的select语句. 至少也应该是 select .. into

Answer 3

like "%@keys%" ?