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 sql server mean?
Who developed sql server?
Explain the etl (extraction, transformation, and loading)?
What is update_statistics command?
What is ms sql server index?
When should you use an instead of trigger?
What is a mutating table error and how can you get around it?
What are the transaction properties?
List the advantages of using stored procedures?
What is an index. What are the types?
Explain syntax for viewing trigger?
How can we get count of the number of records in a table?
Explain Geography datatype in SQL Server
What is compound operators?
What is the difference between delete and truncate statements?