August 9, 2002 at 12:12 pm
Hi,
I am writing an rather large application that is going to be database driven. I am going to have about 30 stored procedures and i want to group them in a way that corresponds to each section of my applcation.
Is there a way to group stored procedures together? Kind of like the way Oracle has packages?
Thanks for you help.
Alex
August 9, 2002 at 12:18 pm
All things are relative!! I don't call 30 stored procedures a large application, even mine with 750 stored procedures is not particularly big I don't think.
The short answer I believe is no. The simplest way is to name them such that they appear together in the EM...just don't let them start with sp_ ...
Regards
Simon
August 9, 2002 at 12:30 pm
I agree 30 isnt a lot, but it can grow over time. I just use a naming convention, usp_tablename_whatdoes it do for access procs, usp_group_whatdoesitdo for specialized stuff. There is a way to group stored procs so that you can drop all in one shot - look at the ';1' syntax in BOL. Not worth using in my opinion.
Andy
August 12, 2002 at 1:01 am
Same here.
We try to add a prefix to 'all' the objects in our database, to indicate the owner-module of the object.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply