Stored Procedure

  • 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.,

0 comments :

Post a Comment

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger