SQL SERVER 2008 – What is an advantage to using a stored procedure as opposed to passing an SQL query from an application

A stored procedure is pre-loaded in memory for faster execution. It allows the DBMS control of permissions for security purposes. It also eliminates the need to recompile components when minor changes occur to the database.

Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )

 

Advertisements

9 thoughts on “SQL SERVER 2008 – What is an advantage to using a stored procedure as opposed to passing an SQL query from an application

  1. I and my buddies happened to be following the best recommendations on your web site then the sudden got an awful feeling I never thanked the web blog owner for those techniques. Most of the ladies appeared to be certainly passionate to read through all of them and already have absolutely been tapping into these things. I appreciate you for getting so accommodating and for considering such marvelous tips millions of individuals are really needing to learn about. My personal honest apologies for not saying thanks to you sooner.

  2. Do you mind if I quote a few of your posts as long as I provide credit and sources back to your webpage? My blog site is in the very same niche as yours and my visitors would definitely benefit from some of the information you provide here. Please let me know if this ok with you. Many thanks!

  3. Love your blog, in fact arrived here as a result of hunting yahoo and google for a comparable subject to this particular posting. Which means this may be a tardy response but keep up the great work.

  4. Aw, this was a very nice post. In idea I want to put in writing like this moreover – taking time and actual effort to make a very good article… however what can I say… I procrastinate alot and not at all seem to get one thing done.

  5. After study a number of the blog posts on your website now, and I truly like your method of blogging. I bookmarked it in order to my bookmark website list and will be checking back quickly. Pls check out my website as well and okay know what you think.

  6. Hey there, you actually think about carrying out any cross-posting on other blogs? I’ve got a rather preferred weblog and I might enjoy to own you need to do a invitee submit on my webpage.

  7. Hey very nice blog!! Man .. Beautiful .. Amazing .. I will bookmark your blog and take the feeds also..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s