Ismael J. Carlo
We learn by doing, sharing and reflecting on our mistakes.
Tuesday, October 6, 2009
Searching all columns in a database for data
It's too bad that there's not a set-based way to search the content of all of the columns of a database. Here's an approach to the problem: http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm. My concern with the approach is that it will likely create full page scans across the data but I haven't thought of a better approach. Perhaps when I find some free time I'll take a stab at it.