Microsoft SQL Server How To: Search for Data in a Database

Peter Musu`
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:

  1. Installed APEX SQL Search (Free) — https://www.apexsql.com/sql-tools-search.aspx
  2. Restored the database locally.
  3. Ran APEX SQL Search from within SQL Server Management Studio, ensuring that ‘Exact Match’ is ticked.
  4. Extracted to CSV, created TSQL query to update the data.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

No responses yet

Write a response