search in all tables

Question

User-165695009 posted
i have 13 table in my sql server nd they have no relation how can i search a keyword in all tables?

Answer 1

User1181216341 posted
you could try to use a union ? SELECT Column FROM Table1 WHERE Title LIKE @Search UNION SELECT Column FROM Table2 WHERE Title LIKE @Search UNION SELECT Column FROM Table3 WHERE Title LIKE @Search UNION etc..

Answer 2

User-1412735316 posted

 

You may looking for full text search. Please surf the below link.

http://msdn.microsoft.com/en-us/library/ms142571.aspx

Other wise ur solution is at below link.

http://forums.asp.net/t/1663726.aspx/1?keyword+search+from+multiple+tables+sql+query