Stored Procedure (Best Practices) Question

[cranger01]

I am sure this is up for debate (or maybe there is an obvious answer).

I am creating a database with several tables that will be updated through a CMS. The Programmer requested Insert, Delete, Edit stored procedures.

Is it better to:

1) create 1 stored procedure to handle all 3 functions per table.

2) create 1 sp for each function and each table

3) try to figure out how to create 1 sp for everything.

4) have the programmer call one sp that determines which stored procedure to send the data too.

just curious.

 

[mrdenny]

Insert and update can be easily done in a single procedure. Delete would probably be via a secord procedure.

The best method for doing this will be what ever the best method is for the application. There are no hard and fast rules about this.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[cranger01]

Thanks for the reply.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com