Re: Packages

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 16:48:19 +0200

Unfortunately not (*). A database has a number of stored procedures. Period... :-)
But nothing stop you from having one procedure calling another or having a naming convention with
which you easier see some "grouping".

There actually is one way of grouping stored procedures, like below. Very rarely used, and my guess
is that this is on target list to be removed in the future.

CREATE PROC p;1 AS SELECT 1
CREATE PROC p;2 AS SELECT 2

EXEC p;1
EXEC p;2

DROP PROCEDURE p;1 --No can do

DROP PROCEDURE p --Drops all!!! 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jon" <Jon@discussions.microsoft.com> wrote in message
news:BABA5A45-72F5-45D2-8318-7396FB095C0B@microsoft.com...
> Hello all,
>
> Apologies if this is in the wrong group.
>
> I'm only just starting to use SQL Server 2000 after using Oracle for a
> number of years. Can you tell me if Server 2000 has the concept of packages,
> where I can package all associated stored procs togther. For example, all
> stored procs to do with the Employee table?
>
> Thanks all,
>
> Jon

Relevant Pages

  • Re: Help understanding Stored proc Level Secuirty?
    ... Jasper Smith (SQL Server MVP) ... I set permissions to my Stored Procedures, ... Access to stored procs fail ...
    (microsoft.public.sqlserver.security)
  • Re: Getting rid of stored procedures
    ... >> Have an opinion on the effectiveness of Microsoft Embedded newsgroups? ... > The OP's point is that stored stored procedures have their place. ... people either used stored procs all the time or none at all. ... > build a proper CRUD command. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Statement in C#
    ... Much of the discussion in the link you gave is based on how SQL Server pre-compiles/caches. ... Is this discussion about whether or not to use stored procedures mainly applicable to SQL Server, ... feasible with stored procs unless those procs end up generating dynamic ... are "the only true way" and the other side saying they are not. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Stored procedure;1
    ... "warway" wrote in message ... > and the Enterprise Manager view of the stored procedures don't have ... Sorry - I have seen multiple stored procs with the same name like this ... Do these other PCs have Enterprise Manager? ...
    (microsoft.public.sqlserver.programming)
  • Re: Advatages of Stored Procedures?
    ... stored procedures, you have to know the good and bad. ... stored procs are retained in the procedure cache and the SQL ... Maintenance, as your application ages and needs changed, some stored procs ...
    (microsoft.public.dotnet.framework.adonet)