"Philip" <thethrill99@yahoo.com> wrote in message
news:a2d3b5cf.0309121907.6c4070c4@posting.google.com...
> Hi all,
> Question from a guy who knows PL/SQL, but is starting with
> Transac-SQL on SQL Server....
>
> Is it possible to have a sub procedure in a Stored Procedure, like
> we do in a PL/sql package ? Or better yet, have a kind of general
> Stored Procedure that would contain procedures called by more than one
> Stored Proc??
>
> I can't find anything like this in the online books....
>
> Thanks for your inputs....
>
> Philip

"John Bell" <jbellnewsposts@hotmail.com> wrote in message news:<3f62ddb7$0$12640$afc38c87@news.easynet.co.uk>...
> Hi
>
> SQL Server does not have packages and limited scope for shared variables.
>
> http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
> http://tinyurl.com/n7v6
> http://www.algonet.se/~sommar/share_data.html
> http://tinyurl.com/n7vc
> http://www.algonet.se/~sommar/dynamic_sql.html
>
> In general there should be no need to create a stored procedure within
> another stored procedure, therefore I think you should think about your
> requirements and design, rather than to do a parallel implementation that
> mimicks your Oracle code.
>
> John
>
>
>
> "Philip" <thethrill99@yahoo.com> wrote in message
> news:a2d3b5cf.0309121907.6c4070c4@posting.google.com...
> > Hi all,
> > Question from a guy who knows PL/SQL, but is starting with
> > Transac-SQL on SQL Server....
> >
> > Is it possible to have a sub procedure in a Stored Procedure, like
> > we do in a PL/sql package ? Or better yet, have a kind of general
> > Stored Procedure that would contain procedures called by more than one
> > Stored Proc??
> >
> > I can't find anything like this in the online books....
> >
> > Thanks for your inputs....
> >