Difference between Function and Stored Procedure?
Answer Posted / madhu
stored procedure when executed generates execution plan
once and next time when it is executed again it will use
the generated execution plan,it does not generate it again.
Function compiles from the beginning and prepares the trace
or execution each time it is called.
Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
What does COMMIT command do?
What are the different kinds of ssrs reports?
What is cube dimension? : sql server analysis services, ssas
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Explain ranking functions?
Can we add a cpu to sql server?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
can a database be shrunk with users active? : Sql server administration
What happens if null values are involved in datetime operations?
What is the difference between varchar and nvarchar datatypes?
When columns are added to existing tables, what do they initially contain?
What is the difference between NOROW and LOCKROW?
How to modify the underlying query of an existing view?
How to connect sql server management studio express to sql server 2005 express?
What is autocommit mode in sql server?