TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ellen Hu
NA
63
0
SQL 2008 Text Search (FREETEXTTABLE, formsof, thesaurus )
Aug 5 2010 6:31 PM
Hi All,
I have problem with my search stored procedure. My table (tblCharity) has almost 2,000,000 records. I need search by the order of Name, Mission.
Say my keyword ='American National red cross', there is no problem for me to pop up the first one with exact matching name.
Then ideally should come most match words, say has 'American Red Cross" or "Red Cross"... but the result seems different, it cannot identify the most match.
I used something like
@OrgSqlStatement = 'INNER JOIN CONTAINSTABLE(tblCharity, zName, ''formsof(thesaurus,"' + @OrganizationName + '")'') AS KEY_TBL
ON C.zCharityId = KEY_TBL.[KEY]'
and INNER JOIN FREETEXTTABLE(tblCharity, zMission,@OrganizationName) AS KEY_TBL ON C.zCharityId = KEY_TBL.[KEY]
Any thoughts? Thank you in advance,
ellen4j
Reply
Answers (
0
)
HOW TO SAVE PRINT VARIABLE INTO ANOTHER VARIALBE IN SQL SERVER
How To resolve this ERROR "A potentially dangerous Request.Form value was detected from the client "in ms sql