≡ Menu

search for string in every table and field – SQL Server

by Jon H. Williams on 2013/08/17

SQL Server: Search Every Table And Field

An important query to have in your toolbox will search through tables and fields.
One may Set a search string.
One may Create a stored procedure.

steps

Follow the external link.
Copy.
Follow the instructions.

description

There are times when getting granular on the backend is a good thing.

external links

Search every table and field in a SQL Server Database Updated | Tim Gaunt.

{ 0 comments… add one }

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Next post: Primer On FCM ARM SOA In Oracle EPM Suite

Previous post: it is time to upgrade the X2-4: X3-4 is here

Follow @jonhwilliams

The retail links in our stories, may allow us to earn a small commission. Also, this site is strictly personal experience and personal observation.

I do not express the opinions of, nor do I express the positions of my my employer, clients or colleagues. This site, epm.jonhwilliams.com, in this and other fora expresses personal experiences, personal perspectives and personal opinions. There are also re-expressions of others’ opinions (a.k.a, stuff I found on the Internet) for which every effort is made to appropriately credit. In case of exception, let me know and I will work with you to resolve. Thank you for your patience with this disclaimer, as it was made necessary by the lawyers.”