0The benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include.
1. They allow faster execution:
overall request-response traffic from client-server communication is much more optimised.
2. They can reduce network traffic.
What overall traffic for server responses return for the client request is reduced due to the mechanism of stored procedures. If less traffic the application runs much faster.
3. They can be used as a security mechanism.
By means of stored procedures, important database features like table name and its column names field remain unopen in the server side coding in ado.net .hence acts like a security mechanism. Hackers even if they invade into the code they cannot come across the database features. Database features are protected.
