INFLECTIONAL FORM OF...FULL TEXT SEARCH..HELP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

INFLECTIONAL FORM OF...FULL TEXT SEARCH..HELP

Author

Topic

bluestar
Posting Yak Master

133 Posts

Posted - 2008-08-11 : 12:58:04

Hello

I want to write stored procedure,which will use FormsOF Inflectional,

BUT I am getting error,actually I dont know how to pass parameter in the Inflectional query.

here it goes....
USE [charlotte]
GO
/****** Object: StoredProcedure [dbo].[sp_AdvanceSearch] Script Date: 08/11/2008 12:46:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_AdvanceSearch]

@Text VARCHAR(300)

As
Begin
Set nocount on;

Select s.SystemElementID,DocumentID, SETitleText as "Title",ElementText as "SearchElement"

FROM TextElement t,SystemElement s,TOCMap tp,TableOfContents tc

Where t.SystemElementID=s.SystemElementID AND Freetext(ElementText,'FORMSOF(INFLECTIONAL,'+@Test+')') AND s.SystemElementID=tp.SystemElementID AND tp.TableOfContentsID=tc.TableOfContentsID

END

If I am using '+' before and after @text,then also it is giving me error,

Please help,I have been trying to do this from long time.

Thank You

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-11 : 23:35:26

You need build dynamic sql.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources