Monday, March 26, 2012

Packages

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,
JonJon
No, It does not exist in SQL Server in this concept but it does exist in
concept of DTS packages to copy/modify data
"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|||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|||Thanks guys.
"Jon" wrote:
> 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

No comments:

Post a Comment