Dear all:
I'm looking for a clever way of finding where a piece of information is
stored.
I want to do the equivalent of: "SELECT * FROM "Any table in the DB" WHERE
"Any field anywhere" LIKE '%xxx%'"
The idea is, i want the system to give me all the records in which any field
contains this piece of information.
This is a SQL Server DB, in case it helps.
The best idea i've come up with so far is to use the stored procedures
provided by SQL server to list the tables, and their fields, and making a
program that will create a SQL statement per each table, with a "WHERE
field1 LIKE '%xxx%' OR field2 LIKE '%xxx%' ... ad infinitum", then running
them all, and showing up the ones that actually came back with results....
Can anyone think of a better way of doing such a thing?
Thanks in advance
Daniel Magliola
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
