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.
No comments:
Post a Comment