Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svudhya
Starting Member
3 Posts |
 Posted - 2010-01-28 : 07:57:36
|
| Does SQL Server supports the concept of a stored procedure package?? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-28 : 08:03:18
|
| Stored Procedures = yes.What's a "package" in this context? |
 |
|
|
svudhya
Starting Member
3 Posts |
Posted - 2010-01-28 : 08:10:40
|
Stored procedure package is a kind of logical unit that groups 2 or more stored procedures as a single unit and stored together in the database for continued use as a unit.Does any version of SQL Server support this feature? Please help. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-28 : 08:14:16
|
| Don't think so. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-28 : 08:17:09
|
| Actually, I don't think its what you want, but you can have MyStoredProcedure;1 MyStoredProcedure;2 and so on. I think they are stored as a "unit". Never used them though ...See http://msdn.microsoft.com/en-us/library/ms187926.aspx |
|
|
|
svudhya
Starting Member
3 Posts |
Posted - 2010-01-28 : 08:21:01
|
| Actually, similar feature is available in oracle PL/SQL. Just wanted to check whether the same feature is available in SQL Server. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-28 : 08:53:04
|
| Yeah, I assumed as much. However, if you were migrating from Oracle to SQL Server would that be important? I don't think a "port" is really feasible, needs to be a "rewrite" ... and then you would adopt SQL Server best practices, rather than just sticking to Oracle methods, don't you think? |
|
|
|
|
|
|
packaging in SQL server stored procedures