What are stored-procedures? And what are the advantages of using them.

• Triggers are stored procedures.it is fired implicitly when insert,delete or update statements are issued against the table on which trigger is defined.
• 11 years agoHelpfull: Yes(0) No(0)
• Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure
  executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.
• 10 years agoHelpfull: Yes(0) No(0)
• Stored Procedure is a function consists of many SQL statement to access the database system.
  Many SQL statements are consolidated into a stored procedure and execute them whenever and
  wherever required.
  It is already compiled one. Main purpose is reusablity
• 7 years agoHelpfull: Yes(0) No(0)