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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Is this bad technique?

Author  Topic 

Blastrix
Posting Yak Master

208 Posts

Posted - 2001-05-23 : 11:01:04
I was wondering if creating a stored procedure in such a fashion is considered bad technique, or no big deal.

I run my stored procedures from ASP pages. On my ASP pages all the functions of certain things are all done in one page using different methods that are passed to it. Is it okay to build a stored procedure where all those functions are contained within on procedure, and there is a value passed to the SP telling it which block of code it should execute? Or should I just keep everything seperate?

   

- Advertisement -