Hello

Can we create a new Package in SQL Server (T-SQL). Oracle has the option of creating a new package using 'CREATE PACKAGE'

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/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

-Sue

On Wed, 31 Mar 2004 22:56:09 -0800, Aparna
[quoted text, click to view]