Red Gate forums :: View topic - Search for "*" AND "*"
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

Search for "*" AND "*"

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
aaronward



Joined: 28 Nov 2011
Posts: 1
Location: Clearwater, FL

PostPosted: Mon Nov 28, 2011 9:05 pm    Post subject: Search for "*" AND "*" Reply with quote

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? Laughing

Thanks!
_________________
______
Aaron Ward
Back to top
View user's profile Send private message
ron2112



Joined: 03 Feb 2010
Posts: 2

PostPosted: Thu Dec 08, 2011 4:08 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
astebler



Joined: 03 Apr 2007
Posts: 1

PostPosted: Wed Apr 04, 2012 7:29 pm    Post subject: Reply with quote

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 ....
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group