Why we are Useing Stored Procedures ?

There are several advantages of using stored procedures instead of standard SQL.

1. Stored procedures allow a lot more flexibility offering capabilities such as conditional logic.

2. Because stored procedures are stored within the DBMS, bandwidth and execution time are reduced. This is because a single stored procedure can execute a complex set of SQL statements.

3. SQL Server pre-compiles stored procedures such that they execute optimally.

4. Client developers are abstracted from complex designs. They would simply need to know the stored procedure's name and the type of data it returns.