Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 21740 Views
- C1 India, NA, I also Faced
- E-Mail Answers
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
how we use window authentication connection with sql server.?
Why SQL Agent is used?
What is a rownum?
How to test odbc dsn connection settings?
What do you know about normalization and de- normalization?
What is statement level trigger?
Define Joins?
How do I create a stored procedure in dbml?
Do I need a report server to run reports in my application?
What is the security principal at the database level that represents your session?
What is the difference between rank and dense_rank?
What are a scheduled jobs?
Why use “nolock” in sql server?
What are group functions in query statements in ms sql server?
What does truncate do?
