AND?

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

AND?

Postby ron2112 » Wed Feb 03, 2010 1:56 pm

Great tool! I think I can probably stop using SQL HelpBuilder now!

The search seems to do an OR if you enter multiple search terms. Putting AND between the terms simply treats it as the word "and". Is there any way of doing an AND search?

Ron Moses
---------
Avoid infestation. Rotate.
ron2112
 
Posts: 2
Joined: Wed Feb 03, 2010 1:53 pm

i wish it could do an OR

Postby krjoyner » Mon Jan 17, 2011 9:55 pm

You sure you're describing it right? When I type in two strings it does an AND search. Such as "APPLE ORANGE" gets me all results where both apple and orange are in the metadata. However I can not get it to do an OR so that i get all results whether they have either APPLE or ORANGE.

This would be a good feature to add since I need to be able to search for multiple hard coded numeric values, sometimes in the hundreds.
krjoyner
 
Posts: 2
Joined: Mon Jan 17, 2011 9:50 pm

Postby David Atkinson » Tue Jan 18, 2011 12:44 am

Yes, you're right - it won't do OR yet.

Your only option is to do each search individually, and maybe copy and paste the results into excel if you need to aggregate them.

Thanks for the request!

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests