Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Arrow Unanswered: What is stored procedure?

    Hi,

    Me I knew what is stored procedure? and What is the use of it? What is the step in order to make a stored procedure?

    Thanks...

  2. #2
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. Each application needing to perform that task can then simply execute the stored procedure. Coding business logic into a single stored procedure also offers a single point of control for ensuring that business rules are correctly enforced.

    This is just a tip of an iceberg..For more info refer Books online.
    Sudar

    --
    My Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •