Creating a Package in SQL Server (T-SQL)

Hello,
Can we create a new Package in SQL Server (T-SQL). Oracle has the option of
creating a new package using 'CREATE PACKAGE'.
Is SQL Server has anything similar to this.Hi Aparna,
SQL Server doesn't have the concept of a package. You can
group stored procedures in SQL Server but it's nothing like
having a package, doesn't have the functionality of packages
(i.e. no package level variables to be used by other
procedures in the package) - it's really not the same thing
at all.
I don't know if have seen the following or not but there is
chapter in the SQL Server 2000 resource kit on migrating
Oracle databases to SQL Server. It has a lot of useful
information to help with such a migration. You can find it
online at:
Chapter 7 - Migrating Oracle Databases to SQL Server 2000
http://www.microsoft.com/resources/...r />
0761.mspx
-Sue
On Wed, 31 Mar 2004 22:56:09 -0800, Aparna
<aparna.shirodkar@.lycos.com> wrote:

>Hello,
>Can we create a new Package in SQL Server (T-SQL). Oracle has the option of
creating a new package using 'CREATE PACKAGE'.
>Is SQL Server has anything similar to this.|||Hi Sue,
Thanx once again for the help. I will go thru the link u mentioned. Let's ho
pe our problem gets resolved.|||Hi Aparna
Good try, hope you are fine. Just flashing old memories. bye
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com