Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Reply
in semantic database want to get rank of every word in conat
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
payal jain
8y
354
1
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
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