How you can find a string in a SQL database? One option would be to export the database to Excel file and use the Excel searching capabilities. Unfortunately I did not manage to get the export working for me at all. If you want to do it the smart way, here is a query that search all tables and columns in a database written by from Vyas Kondreddi. Another one is available for replacing string in a database.
Labels: SQL, Tools and Tips