使用参数进行搜索的存储过程是什么 [英] What is the stored procedure for search using parameter

问题描述

如何在SQL中使用参数storedproc搜索两个以上的单词.示例搜索"Project Manager Books"(即使以任何一种方式键入，并且即使句子以"Manager"开头和以"Project"结尾)也是如此，只要该句子包含这三个单词，它就必须仅返回包含"Project Manager"的句子图书".

How to search for more than 2 words using parameter storedproc in SQL. Example search for "Project Manager Books" even if its typed either way and even if the sentence start by "Manager" and end by "Project" as long that sentence have those 3 words, it must return only the sentences that contain "Project Manager Books".

推荐答案

您可以使用CONTAINS 关键字来进行这种

You can use the CONTAINS keyword to do this kind of a search[^].

您可以使用全文搜索 [^ ]在SQL Server中.

另外，请查看 CONTAINS(Transact-SQL) [

You can use Full-Text Search[^] in SQL Server.

Also, look at CONTAINS (Transact-SQL)[^]

这篇关于使用参数进行搜索的存储过程是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！