• What is a stored procedure?

    Answered

    What is a stored procedure?

    Bronze Member Asked on June 2, 2016 in Sql.
    Add Comment
  • 3 Answer(s)
    Best answer

    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.

    Bronze Member Answered on June 20, 2016.
    Add Comment

    A procedure is a group of PL/SQL statements that can be called by a name. Procedures do not return values they perform tasks.

    Bronze Member Answered on June 2, 2016.
    Add Comment

    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.

    Bronze Member Answered on June 20, 2016.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.