Best practices
Which is best practice individual stored procedure for every action or only one stored procedure for entire project?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Girish SapariyaPosted Jan 6, 2014, 3:01 AM
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.