Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, June 17, 2016 9:45 AM
Points: 3,476, Visits: 1,940
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


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 19, 2015 6:21 AM
Points: 706, Visits: 328
Thank you. Very useful and simple.
Post #1422945
Posted Tuesday, May 10, 2016 1:45 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:21 AM
Points: 7,841, Visits: 755
Thanks for the script.
Post #1784908
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse