Search for "*" AND "*"

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

Search for "*" AND "*"

Postby aaronward » Mon Nov 28, 2011 9:05 pm

Attempting to search for: "Update MyTable" AND "IsActive = 0" amongst all stored procedures returns no results.

However, upon entering a double quote (") the return result set is empty anyhow.

Does this functionality exist at all? If so, how would one go about mastering its technique? :lol:

Thanks!
______
Aaron Ward
aaronward
 
Posts: 1
Joined: Mon Nov 28, 2011 8:56 pm
Location: Clearwater, FL

Postby ron2112 » Thu Dec 08, 2011 4:08 pm

I usually hate to make "+1" posts, but I agree this is something that is desperately needed. I need to find all procedures where the value of a certain field from a certain table is being used, and if I search for the table name and the field name, I'm going to get a huge number of irrelevant results.

EDIT: Looking at this again, it does appear to do an AND search on a simple list of single-word terms. So my needs are met in that department. Obviously not so good in the original poster's case.

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

Postby astebler » Wed Apr 04, 2012 7:29 pm

I assume you are looking for instances of "Select *"

One possible way is locate "*" is to search for "/*" or "\\*" (without the quotes) - this will produce results many of which are relevant. I believe this works because of regex, which I think is how the search is being conducted.

Alternatively you could search for "Select *" (again no qoutes) and check the 'Exact Match' option. This will miss things like 'table1.*'.
The \"guest\" account really is important ....
astebler
 
Posts: 1
Joined: Tue Apr 03, 2007 9:04 pm


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 1 guest