| Author: Vijaykumar Patil 05 May 2008 | Member Level: Gold Points : 2 |
Stored procedure:
A stored procedure is a program (or procedure), which is physically stored within a database. They are usually written in a proprietary database language like PL/SQL for Oracle database or PL/PgSQL for PostgreSQL. The advantage of a stored procedure is that when it is run, in response to a user request, it is run directly by the database engine, which usually runs on a separate database server. As such, it has direct access to the data it needs to manipulate and only needs to send its results back to the user, doing away with the overhead of communicating large amounts of data back and forth.
|
| Author: Vijaykumar Patil 05 May 2008 | Member Level: Gold Points : 2 |
Advantages of Stored Procedure.
Answer:
Stored procedure can reduce network traffic and latency, boosting application performance.
Stored procedure execution plans can be reused, staying cached in SQL Server’s memory, reducing server overhead.
Stored procedures help promote code reuse.
Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
Stored procedures provide better security to your data.
|
| Author: venkat kamal 05 May 2008 | Member Level: Gold Points : 2 |
A stored procedure is a set of Standard Query Language statements which can be compiled and stored in a database so that we can use it whenever we wants in any program...........
|
| Author: Deepthi 05 May 2008 | Member Level: Silver Points : 2 |
A stored procedure is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored procedure instead.
|
| Author: Shilpa Ginode 05 May 2008 | Member Level: Gold Points : 2 |
We can execute one stored procedure inside another stored procedure.
Just we need to write:
EXEC [STored Procedure 1]
in the second stored procedure.
|