Best practices

Question

Which is best practice individual stored procedure for every action or only one stored procedure for entire project ?

Girish Sapariya · Answer

hi Parthiban if you keep one store procedure for entire project then your storred procedure will look like junk i.e lots of logic conditions and cases. Its better to have individual stored procedure for every action. You can keep one procedure for Insert/Update/Delete action of same type. e.g: Insertion of new employee or updating an employee or deleting a record of an employee The above situation can have one single procedure with 3 cases. The code will be easy to understand.