Re: Can I set multiple filters?
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Wed, 8 Nov 2006 08:18:15 -0800
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29D3B28A-D744-45F9-84C7-D4278EB9086C@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:324C281E-00E1-4B79-A7F6-D25BB6DF71FE@xxxxxxxxxxxxxxxx
That would be taking step back toward stone age. What is the point of
nice
UI if not very useful?
"Arnie Rowland" wrote:
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B7B8AC7C-96E7-469E-B443-3ECE47C7DCDA@xxxxxxxxxxxxxxxx
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?
.
- References:
- Re: Can I set multiple filters?
- From: Arnie Rowland
- Re: Can I set multiple filters?
- From: Arnie Rowland
- Re: Can I set multiple filters?
- From: Todd
- Re: Can I set multiple filters?
- Prev by Date: Re: Can I set multiple filters?
- Next by Date: Re: Can I set multiple filters?
- Previous by thread: Re: Can I set multiple filters?
- Next by thread: Re: Can I set multiple filters?
- Index(es):
Relevant Pages
|
