Stored procedures

700 pts.
Tags:
SQL statements
Stored Procedures
What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

Software/Hardware used:
software

Answer Wiki

Thanks. We'll let you know when a new response is added.

A stored procedure is a set of SQL statements that can be shared by multiple programs.

You can find more of an explanation here: “Stored procedure

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    A quick Google search for [ stored procedure ] brings up many links, including a Wikipedia article that gives a fairly good discussion. There doesn't seem to be a good reason to duplicate any of those here. -- Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    A stored procedure is a good way of creating re-usable code across multiple platforms. We have some RPG programs that we used to create some stored procedures. We can now use these in our web applications as well as the corporate green screen code. It only needs to be maintained in one place which keeps things in sync.
    12,745 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following