Can I set multiple filters?

I am using SQL Server 2005 Express Management Studio. I want to put in
multiple filters for stored procedure. Example: where sp name contains
'spFNP or spNGFM'. Is this possible? If so, what is the syntax?
Also, is there a way to save filter between sessions?
Unfortunately, it appears that you cannot.
If you are trying to obtain a list of all stored procedures that have certain characters in their name, you might try a query like this:
SELECT [name]
FROM sys.procedures
WHERE ( [name] LIKE 'spFNP%'
OR [name] LIKE 'spNGRM%'
)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the top yourself.
- H. Norman Schwarzkopf
"Todd" <Todd@.discussions.microsoft.com> wrote in message news:B7B8AC7C-96E7-469E-B443-3ECE47C7DCDA@.microsoft.com...
>I am using SQL Server 2005 Express Management Studio. I want to put in
> multiple filters for stored procedure. Example: where sp name contains
> 'spFNP or spNGFM'. Is this possible? If so, what is the syntax?
> Also, is there a way to save filter between sessions?
|||That would be taking step back toward stone age. What is the point of nice
UI if not very useful?
"Arnie Rowland" wrote:
[vbcol=seagreen]
> Unfortunately, it appears that you cannot.
> If you are trying to obtain a list of all stored procedures that have certain characters in their name, you might try a query like this:
> SELECT [name]
> FROM sys.procedures
> WHERE ( [name] LIKE 'spFNP%'
> OR [name] LIKE 'spNGRM%'
> )
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the top yourself.
> - H. Norman Schwarzkopf
>
> "Todd" <Todd@.discussions.microsoft.com> wrote in message news:B7B8AC7C-96E7-469E-B443-3ECE47C7DCDA@.microsoft.com...
|||Sorry you feel that way. In fact, most 'professionals' that regularly work
with SQL Server (and Oracle, etc.) do NOT use the "nice UI" for queries.
The best way to query the database is to know how to query the database and
not rely upon a GUI.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:324C281E-00E1-4B79-A7F6-D25BB6DF71FE@.microsoft.com...[vbcol=seagreen]
> That would be taking step back toward stone age. What is the point of
> nice
> UI if not very useful?
> "Arnie Rowland" wrote:
|||Sorry, we can't all be 'professionals' like you. MS went to the trouble to
build Express version for us developers who would rather have UI instead.
Just because you would rather type:
SELECT [name]
FROM sys.procedures
WHERE ( [name] LIKE 'spFNP%'
OR [name] LIKE 'spNGRM%')
... I would prefer to only type 'spFNP;spNGRM' in a textbox, doesn't make me
less 'professional'. Just more efficient. My time is valuable. I could
write .Net in Notepad too, but would defeat the purpose of Visual Studio.
MS - Please add support for multiple filters in next version for us folks
who want easy way out.
"Arnie Rowland" wrote:

> Sorry you feel that way. In fact, most 'professionals' that regularly work
> with SQL Server (and Oracle, etc.) do NOT use the "nice UI" for queries.
> The best way to query the database is to know how to query the database and
> not rely upon a GUI.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Todd" <Todd@.discussions.microsoft.com> wrote in message
> news:324C281E-00E1-4B79-A7F6-D25BB6DF71FE@.microsoft.com...
>
>
|||Post your suggestions for SQL Server here:
Suggestions for SQL Server
http://connect.microsoft.com/sqlserver
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:29D3B28A-D744-45F9-84C7-D4278EB9086C@.microsoft.com...[vbcol=seagreen]
> Sorry, we can't all be 'professionals' like you. MS went to the trouble
> to
> build Express version for us developers who would rather have UI instead.
> Just because you would rather type:
> SELECT [name]
> FROM sys.procedures
> WHERE ( [name] LIKE 'spFNP%'
> OR [name] LIKE 'spNGRM%')
> ... I would prefer to only type 'spFNP;spNGRM' in a textbox, doesn't make
> me
> less 'professional'. Just more efficient. My time is valuable. I could
> write .Net in Notepad too, but would defeat the purpose of Visual Studio.
> MS - Please add support for multiple filters in next version for us folks
> who want easy way out.
> "Arnie Rowland" wrote:
|||"Professional" is finding ways to work with the tools you have instead of
bemoaning that the tools you want aren't available.
"Professional" is working to improve the product by offering suggestions.
Please post your suggestion for product improvement.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:29D3B28A-D744-45F9-84C7-D4278EB9086C@.microsoft.com...[vbcol=seagreen]
> Sorry, we can't all be 'professionals' like you. MS went to the trouble
> to
> build Express version for us developers who would rather have UI instead.
> Just because you would rather type:
> SELECT [name]
> FROM sys.procedures
> WHERE ( [name] LIKE 'spFNP%'
> OR [name] LIKE 'spNGRM%')
> ... I would prefer to only type 'spFNP;spNGRM' in a textbox, doesn't make
> me
> less 'professional'. Just more efficient. My time is valuable. I could
> write .Net in Notepad too, but would defeat the purpose of Visual Studio.
> MS - Please add support for multiple filters in next version for us folks
> who want easy way out.
> "Arnie Rowland" wrote: