Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 'all table' queries

Author  Topic 

mattt
Posting Yak Master

194 Posts

Posted - 2001-11-15 : 05:06:04
Hi,

Is it possible to write a 'general' query for a relational database where every value in every column of every table in the database is tried as a match against a query string? I know it's possible if you sprcify every table and every column in your SELECT statement, joined together with OR but I wondered if there was a more 'shorthand' way of doing it?

   

- Advertisement -