Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
0
Reply
in semantic database want to get rank of every word in conat
payal jain
Jan 6 2016 12:26 PM
343
Reply
sPlease help me............................................
In semanctic databse
set @str='java and sql and unix devloper or php and fox devloper'
SELECT K.RANK, AddressLine1, City
FROM Person.Address AS A
INNER JOIN
CONTAINSTABLE(Person.Address, AddressLine1,@str) AS K
ON A.AddressID = K.[KEY]
above code fetches the rank of complete string when string str is passed to function CONTAINSTABLE.
but I need it separates all the words and fetches the rank of all the words. Separator should be 'AND' or 'OR'.
output should be in format of commseperated rank with every word like this
seperator and ,or
word rank
java 23
sql 21
unix devloper 20
php 30
fox devloper 23
Improve question Permalink
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
How To Understand Before Next Day is in Table
Why do we use only the special symbol ‘*’ in select statemen