lunedì 12 marzo 2012 07:01
Tutte le risposte
lunedì 12 marzo 2012 08:34
Your descriptions are not complete. What do you mean by a 'Search Engine Query'? If you want to find rows having a particular name then you can use a simple LIKE predicate like this:
SELECT * FROM Faculty WHERE FacultyName LIKE '%BALA WHEERE%'
However this will not be SARGable (index freindly). If your application has to do a wide variety of character searches then the best option is to go for Full Text Search feature in SQL Server. Have a look at the below link for a start up.
- Krishnakumar S
lunedì 12 marzo 2012 17:03Postatore
The following article has a stored procedure to search the entire database for a keyword:
Kalman Toth SQL SERVER & BI TRAINING
lunedì 12 marzo 2012 19:23please provide sample table and data scripts for more help. your question is not clear