Complete Database search query

Question

My web Application need to integrate the search button same like google search,In these search button i need to search complete database for these matching string. How to write a query for these issue because i need to write in where clause multiple tables of the database to get that string record.

Rajeev Punhani · Accepted Answer

Hi Kiran, You can create a procedure that can search all the tables for the particular keyword and show the result.Please have a look at the below link . http://stackoverflow.com/questions/436351/how-do-i-find-a-value-anywhere-in-a-sql-server-database If the above solution is helpful then, accept the answer.

kalu singh rao · Answer

Why not you use search for getting all related data from database, if you want to get data from multiple tables, then you create a store procedure (SP) and pass searching text as argument, use in the SP to find out data.