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/d...rt2/c0761.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 hope 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