Niranjan Thapa
hi,
I need to search "multiple tables"/"columns in a single table" with containstable. I would be grateful if anyone could give a hint
Thank you..
Transact-SQL
You could use few select queries with containstable - one for each table and column. Then combine results using UNION
SELECT * FROM Table1 join ContainsTable(...)
UNION
SELECT * FROM Table2 join ContainsTable(...)
....