如何将存储过程编写为全文搜索 [英] How to write Stored Procedure as Full text Search

问题描述

所有老师，...
以查询方式编写的朋友有在SQL Server中进行全文搜索的经验
谁使此存储过程作为常规的全文搜索，其中包含和..被用作

我对所有朋友的完美表示感谢.

电子邮件:[e-mail]

hi to all teachers,...
Friends who write in the query mode Full text Search in Sql Server have experience
Who make this Stored Procedure as a normal Full text Search, which contains and .. Is used, into

Advance of the tips I have thanked all friends perfection.

Email : [e-mail]

Create PROCEDURE Sp_student
@fname varchar(50),
@lname varchar(50),
@tel varchar(50),
@code varchar(50),
@adr varchar(50),
@search_operation varchar(50),
@totalRowCount bigint output
AS
begin
if @search_operation = ''and''  
begin
SELECT f3,f4,f5,f6,f7  FROM tb_student
WHERE(
f5  like  ''%'' + @fname + ''%'' and
f4  like  ''%''  + @lname + ''%'' and 
f6   like  ''%''  +   @tel  + ''%'' and
f7   like  ''%''  +   @code  + ''%'' and
f3  like  ''%'' + @adr +''%'' 
)
select  @totalRowCount = @@rowcount
end

推荐答案

我相信您需要配置数据库和相关表才能进行全文搜索.您进行过Google搜索或检查过任何书籍吗?

I believe you need to configure your database and the table in question for full text search. Have you done a google search or checked any books ?

这篇关于如何将存储过程编写为全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！