[dba-SQLServer] Tell Query analyzer where to store queries

Robert L. Stewart rl_stewart at highstream.net
Fri Nov 3 10:58:56 CST 2006


John,

If you are repeating them, store them as stored procedures.

For example:

CREATE PROCEDURE  uspGetPostalCodeCount
         @PostalCode varchar(5)
AS
      SELECT COUNT(PostalCode)
      FROM dbo.tblNameAddress
      WHERE PostalCode = @PostalCOde

Robert

At 10:49 AM 11/3/2006, you wrote:
>Date: Fri, 3 Nov 2006 11:15:27 -0500
>From: "JWColby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Tell Query analyzer where to store queries
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <009301c6ff63$475f9750$657aa8c0 at m6805>
>Content-Type: text/plain;       charset="us-ascii"
>
>Is there any way to tell query analyzer where to save queries I am building,
>preferably on a database level?  It is just "offering" to save them in my
>documents.  Not useful to have to navigate over to another drive / directory
>structure every time I want to save a query.  Also not helpful to have a
>thousand queries all stuffed in my documents.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>





More information about the dba-SQLServer mailing list