Does anyone know an easy way to search for a string in a SQL Server database.
« Back
Tags:
Question ID: 104194
▲
3
▼
♥ 0

I’m trying to learn all about how things QC store information in the project database.
Does anyone have a stored procedure or SQL that can search for text strings?

Marked as spam
Posted by (Questions: 5, Answers: 1)
Asked on August 13, 2010 2:48 pm
57 views
Answers (1)
▲
4
▼
✔
Private answer

I have used this one. Works really well.

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on August 13, 2010 2:56 pm
▲
0
▼
Thank you, that is exactly what I am looking for.
( at August 13, 2010 2:59 pm)
▲
0
▼
That works great. Note to others, use a single quote instead of double quotes around the string. For example SearchAllTables 'FindThisText'
( at August 13, 2010 3:03 pm)
▲
0
▼
Alway glad to help where I can.
( at August 13, 2010 3:04 pm)
« Back
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Got it!
X
Scroll to Top