Microsoft SQL Server How To: Search for Data in a Database
1 min readAug 5, 2020
Microsoft SQL Server How To: Search for Data in a Database
Scenario: Some data had brackets ‘(‘, ‘)’ which were causing a program to give an error.
To find all the areas which needed to be modified:
- Installed APEX SQL Search (Free) — https://www.apexsql.com/sql-tools-search.aspx
- Restored the database locally.
- Ran APEX SQL Search from within SQL Server Management Studio, ensuring that ‘Exact Match’ is ticked.
- Extracted to CSV, created TSQL query to update the data.