Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22099 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
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to create a local temporary stored procedure?
Can you edit the .rdl code associated with a linked report?
What is change data capture (cdc) in sql server 2008?
Tell me what is fill factor?
What is read committed?
What is fill factor and pad index?
What are different types of schemas?
How do you delete duplicate rows in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
What are .mdf files?
What are key constraints?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
List the different types of joins?
What happens if ntwdblib.dll is missing on your machine?
