.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

What is Precompiled in terms of Stored Procedure in Sql Server?

Posted By: Deco     Posted Date: September 20, 2010    Points:2   Category :Sql Server
I heard from many of them that Stored Procedures are precompiled.

Can any one explain in details on what does a Precompiled mean
and what are the action taken place in precompiled?.

Responses
Author: Jean Paul             
Posted Date: September 27, 2010     Points: 5   

Dude,

I would like to update that Stored Procedures upto Microsoft Sql Server 6.5 was having pre-compiled feature.
Now it is not.

I have read that in the MCTS certification for Sql server. You can confirm it.
http://msdn.microsoft.com/en-us/library/aa174792.aspx

The advantage of pre-compilation is that the first level syntax validation and token generation can be saved.
Now no longer this feature is available.

So one may ask then what is the purpose of stored procedures today:
My suggestions would be:
1) Saving the round trip time in case of the application having an number of queries in a complex businesss logic
2) Using parameters prevents sql injection

Regards.

Jean Paul http://jeanpaulva.com/


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend