March 12, 2012 at 12:56 am
HOW TO WRITE SEARCH ENGINE QUERY FOR A DATABASE CONTAIN 3 TABLES
IMAGINE DATABASE NAME STUDENTDETAIL
WHICH
IS HAVING 3 TABLE
1. FACULTY
2.STUDENT
3.OFFICE STAFF
THE THREE TABLE ARE INNER JOINED BY PRIMARY KEY AND FOREGIN KEYS
FOR EXAMPLE IF I AM SEARCH ING
A WORD 'BALA WHEERE'
IAM JUST TRYING THIS BUT I DIDNT FIND SOLUTION
IF ANY ONE FIND SOLUTION PLEASE SHARE
March 12, 2012 at 1:13 am
Look into the LIKE clause or into Full-Text indexing.
p.s. your caps lock is broken
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 2:59 am
Select *
from tblAdSpace s
join tblMembers m on m.MemberId=s.MemberId
join tblAdInfo i on s.AdSpaceId=i.AdSpaceId
join tblAdBlock b on s.AdSpaceId=b.AdSpaceId
join tblAdContactInfo INF ON INF.AdInfoId=i .AdInfoId
join tblApplicableCategories ACS ON ACS.AdInfoId= i .AdInfoId
join tblAdCategory ac ON ac.CategoryId =ACS.AdInfoId
join tblAdSubCategory sb ON sb .CategoryId = ac.CategoryId
here i joined seven tables
tell me how to use Full-Text Index for searching
March 12, 2012 at 3:01 am
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2012 at 3:59 am
how to use this
Full-Text Search (SQL Server)
in my select query
iam not getting the point in reading this related article
March 12, 2012 at 4:14 am
In short, the point of full text indexing is to create a catalog and a full-text index on your tables.
Using this full-text index, you can use the TSQL function CONTAINS and FREETEXT to search your tables.
Querying SQL Server Using Full-Text Search
This is quite an advanced topic, so you're probably better of with the LIKE operator...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2012 at 7:54 am
er.sivaganesh (3/12/2012)
how to use thisFull-Text Search (SQL Server)
in my select query
iam not getting the point in reading this related article
Full Text Search is a fairly complex subsystem. We cannot do your job for you - we have pointed you to a resource to help (I also recommend Books Online, as well as buying a book that covers FTS). If you cannot understand what to do after you have REALLY read and tried to understand/use the material then you can post SPECIFIC questions back to this forum. Or you can hire a professional to help you understand what you need here AND help you implement the best solution. You have given us VERY little to go on and I am not even convinced that FTS is the appropriate solution.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 13, 2012 at 8:01 am
TheSQLGuru (3/13/2012)
You have given us VERY little to go on and I am not even convinced that FTS is the appropriate solution.
With the little amount of information provided, there's no way of knowing the appropriate solution. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply