Dear Friend
Some reasons for preferring stored procedure are
- Easy maintainability- Stored procedures are easy to maintain and can be directly deployed without recompilation of code
- Increased Performance- When grouping a set of operations in to a single procedure will increase the performance by reducing the number of round trips to the database server
eg - One Insertion and modification (both are depended each other) using procedure will get completed in a single tick to server ; if not implemented the same using procedure, in that case for executing each process application have to go to server and execute the statement - Data Integrity Is Maintained - Consider the above situation if insertion is causing error then without moving to updation the operation will be terminated by raising an error if the operations are implemented using procedure else if insertion is causing error then it may try with updation which is meaning less as insertion caused error
Hope you got an idea and will continue to use stored procedure for further application development
Happy Programming
Vipin Kumar Mallaya