- A Stored procedure is a named group of SQL statements that have been previously created and stored in the server database.
- Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data.
- And when the procedure is modified, all clients automatically get the new version.
- Stored procedures reduce network traffic and improve performance.
- Stored procedures can be used to help ensure the integrity of the database.
- E.g.: sp_helpdb, sp_renamedb, sp_depends etc.,
Stored Procedure
Subscribe to:
Post Comments
(
Atom
)
0 comments :
Post a Comment