如何使用参数在SQL中搜索 [英] How to search in SQL using Parameters

问题描述

什么是用于存储使用参数的存储程序，例如::-如果要搜索项目管理器"，则必须返回其中包含项目管理器"的所有句子.即使您以经理项目"的任何一种方式键入它，即使句子包含项目团队经理"也必须能够返回包含项目经理"的句子.请帮助.

what is a storedprog for searching usig a parameter eg :- if you want to search "Project Manager" it must return all the sentences that contains "Project Manager" in it. even if u typed it either way "Manager Project" and even if a sentence contains "Project Team Manager" must able to return those sentences that contains "Project Manager".Pleas help.

推荐答案

签出:

在存储过程中构建动态SQL [

check this out:

Building Dynamic SQL In a Stored Procedure[^]

hope it helps :)

尝试全面搜索"或您先前提出的问题中提出的建议.不要转发.
如何使用存储过程在SQL Server中搜索文本 [^ ]
http://msdn.microsoft.com/en-us/library/aa174792 (v = sql.80).aspx [

Try Full-Search or whatever suggested in your previous questions. Don''t repost.
How do you search text in SQL server using Storedprocedure[^]
http://msdn.microsoft.com/en-us/library/aa174792(v=sql.80).aspx[^]

这篇关于如何使用参数在SQL中搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！