34,590
社区成员
发帖
与我相关
我的任务
分享
declare @s Nvarchar(100)
set @s='"3" OR "M" OR "MP" OR "MP3" OR "P" OR "P3" OR "本" OR "笔" OR "笔记" OR "笔记本 OR "记"'
SELECT * FROM (SELECT xxxx FROM xx item WHERE CONTAINS(item.[ItemName],@s)
--为什么不行,但是 ,出错提示为消息 7630,级别 15,状态 3,第 5 行
--在全文搜索条件 '"3" OR "M" OR "MP" OR "MP3" OR "P" OR "P3" OR "本" OR "笔" OR "笔记" OR "笔记本 OR "记"' 内的 '记' 附近存在语法错误。
declare @s Nvarchar(100)
set @s='"3" OR "M" OR "MP" OR "MP3" OR "P" OR "P3" OR "本" OR "笔" OR "笔记" OR "笔记本 OR "记"'
SELECT * FROM (SELECT xxxx FROM xx item WHERE CONTAINS(item.[ItemName],‘"3" OR "M" OR "MP" OR "MP3" OR "P" OR "P3" OR "本" OR "笔" OR "笔记" OR "笔记本 OR "记"’)
可以查询
exec('SELECT * FROM (SELECT xxxx FROM xx item WHERE CONTAINS(item.[ItemName],'+@s+')')