如何在SQL Server中搜索文本 [英] How do you search text in SQL server

问题描述

storedproc的用途是什么，如果您想在sql中搜索三个单词或更多文本，例如:-项目管理工作簿"，即使您可以通过输入"management"开始以任何一种方式输入文本，它也必须返回包含项目管理工作簿"

what is the storedproc for, if you want to search three words or more text in sql eg:-"Project management workbook" even though you can enter text either way starting by enter "management" it must return results that have "Project management workbook"

ALTER PROCEDURE [dbo].[sp_Search]  
	@Search varchar(255) 
AS
BEGIN
	
	SET NOCOUNT ON; 
	declare @strpart1 varchar(255) select @strpart1 = SUBSTRING( @Search,CHARINDEX(' ', @Search,1),(LEN(@Search) - CHARINDEX(' ', @Search,1) + 1))
	
    -- Insert statements for procedure here
    Select Description from ['Portal Catalogue$'] 
    where Description Like '%'+@strpart1+'%' 
END

推荐答案

']] 其中说明类似 ' ％' + @ strpart1 + ' ％' END

'] where Description Like '%'+@strpart1+'%' END

其中的描述如''％" + prog +％""

where description like "''%"+prog+"%''"

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