Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Olly on October 05, 2016, 11:59:00 AM

Title: How do you search for a value in a database table when you don't have the exact value to search for?
Post by: Olly on October 05, 2016, 11:59:00 AM
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.
Title: Re: A database
Post by: Patrick on February 19, 2018, 08:20:30 PM
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.