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
Explain for xml explicit mode?
List out the different types of locks available in sql server?
How to count groups returned with the group by clause in ms sql server?
Explain “row_number()” in sql server with an example?
How do I completely remove sql server instance?
How do I shrink an ldf file?
Does hive support indexing?
What does it mean to be in union?
Define indexes?
What is normalization and what are the advantages of it?
What is lock escalation and what is its purpose?
What are the operating modes in which database mirroring runs?
What is lookup override?
How network traffic be reduced by using the stored procedure?
can an automatic recovery be initiated by a user? : Sql server administration