sql server programming: Oracle equivalent of database packages -- sql server programming

Oracle equivalent of database packages

Vishal
11/1/2007 11:15:01 PM

sql server programming: Hi,

I am from oracle background where we have a concept of database packages. A
package is a group of related procedures and functions, together with the
cursors and variables they use, stored together in the database for continued
use as a unit.

In sql server, I am trying to build a functionality which would need about 4
different stored procedures. Instead of creating them as a 4 standalone
procedures I would like to create all of them under a package. Is there a way
to achieve this in sql server ?

I am using sql server 2005

Re: Oracle equivalent of database packages

Tibor Karaszi
11/2/2007 8:35:42 AM

I'm afraid that there is no such concept in SQL Server. Closest you would come is probably using a
separate schema for those objects...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

[quoted text, click to view]