1. Modular Programming- Stored procedures allow developers to encapsulate business functionality and provide callers with a simple interface. Once interfaces are settled down, caller and callee coding work can be assigned to different team/persons.
2. Security Enhancement- Users can be granted permission to execute a stored procedure. Use parameterized queries—not string concatenation—to build queries.
3. Reduce network traffic – Benefits can be easily noticed if you have frequently called T-SQL code of hundreds of lines.
4. Performance – Stored procedures are registered at servers, and as a result DBAs/servers get more change to optimize them.
Coding time now. Firstly, you need run below SQL script in SQL2005.
Next, you can call in ADO.NET.
/// and then read it out with stored procedure "ReadData"