Answer Posted / s.aravindhna

Microsoft SQL Server provides the stored procedure
mechanism to simplify the database development process by
grouping Transact-SQL statements into manageable blocks.

Benefits of Stored Procedures

Why should you use stored procedures? Let's take a look at
the key benefits of this technology:
Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
Efficient reuse of code and programming abstraction. Stored
procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
Stored procedures are very similar to user-defined
functions, but there are subtle differences. For more
information, read Comparing Stored Procedures and User-
Defined Functions.

How can we optimize a sql query?

1031

---

Can we use joins in subquery?

1143

---

Can you call pl/sql package functions from within a fast formula?

1021

---

Can we use the cursor's to create the collection in PL/SQL?

1006

---

how to extract a unit value from a date and time? : Sql dba

979

---

What is sql*loader and what is it used for?

1121

---

Which sorts rows in sql?

1001

---

How does a trigger work?

1044

---

Why is sql*loader direct path so fast?

1091

---

What does closing a cursor do?

1303

---

What are the types of keys?

981

---

What is package in pl sql with an examples?

1020

---

What is the purpose of the partition table?

1034

---

How long will it take to learn pl sql?

925

---

Is keyword pl sql?

963

---