search all nvarchar columns

How can I search all nvarchar columns in a database for a specific text sting?
LVL 1
HLRosenbergerAsked:
Who is Participating?
 
jogosConnect With a Mentor Commented:
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
 
HLRosenbergerAuthor Commented:
got it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.