Stored Procedures in SQL Server 2005

10 pts.
Tags:
SQL Server
SQL Server 2005
SQL Server stored procedures
SQL stored procedures
Stored Procedures
Will you please explain me about Stored Procedures in SQL Server 2005?

Software/Hardware used:
software

Answer Wiki

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

Hi

The stored procedure is another way of executing a query against a database/databases on the sql server, the only difference is that query is stored on the actual server and to execute it you will need to call it.

this feature is usefull for repetitive tasks and if you don’t want the query to be stored on the client machine (example would be a helpdesk first line support person needs to query the database many times a day for a status on the logged calls)

The stored procedure is useful when you want to lock the query down only to some users.

I have described you a very small area where you can apply the stored procedures

I presume you have read this: Stored Procedure Basics

Regards

Discuss This Question: 1  Reply

 
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
  • Rajanarina1
    [...] więcej: Stored Procedures in SQL Server 2005 Tags: server-2005, software, stored, stored-procedures-, you-please Comments RSS [...]
    0 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