Solved

search all nvarchar columns

Posted on 2012-03-30
2
266 Views
Last Modified: 2012-06-21
How can I search all nvarchar columns in a database for a specific text sting?
0
Comment
Question by:HLRosenberger
2 Comments
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 37788521
Nvarchars only? Don't forget that there could be some loose columns with type varchar, text, ntext?????

If it's one time dynamic sql.  Look for all columns (information_schema.Columns) with your datatype and construct your select with it.
0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 37788538
got it.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now