Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Find a text string in any column in a database. Expand / Collapse
Author
Message
Posted Friday, May 18, 2012 2:27 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:14 PM
Points: 3,466, Visits: 1,820
If you are using "results to text" the output will be between the 3rd and 4th "(1 row(s) affected)" .

I'm adding a SET NOCOUNT ON to the top of the script in order to turn off the extra output.

You probably arn't getting any results. If you switch to "results to grid" you will get your results seperate from the text output.

Kenneth


Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
Post #1302834
Posted Friday, February 22, 2013 2:57 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Thank you. Very useful and simple.
Post #1422945
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse