How do you search for a value in a database table when you don't have the exact value to search for?

Started by Indiana, October 05, 2016, 11:59:00 AM

Previous topic - Next topic

Olly

Hello everyone, I have a little strange question, how do you search for a value in a database table when you don’t have the exact value to search for? Thank you very much for answering me on this subject.

Patrick

Using SQL to search for specific data in all tables and all columns of a database is far from an optimal solution. There are various SQL scripts with different approaches that can be used to obtain this information, what they have in common is that they all use cursors and system objects.