Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
What is Precompiled in terms of Stored Procedure in Sql Server?
September 20, 2010
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?.
Posted Date: September 27, 2010 Points: 5
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.
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
To post reply
Related Questions Related Questions
Difference between Stored Procedure and function in Sql Server
Have doubt in store procedure in sql server
i got a problem on registration form using stored procedure and classes
How to get output value from stored procedure?
Table name as parameter in SQL Stored Procedure
get value from output parameter from stored procedure
How do I call a Stored Procedure with one associative array as Out put Parameter ?
How to find the Recently accessed stored Procedure?
Where will the text of the stored procedure gets stored?
how many nested levels are there in Sql Server 2008 for Stored Procedures?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend