Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Function and Stored Procedure?
- 9 Answers
- 22104 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arunvs
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.
sp used to solve a business logic
Function compiles from the beginning and prepares the trace
or execution each time it is called.function can be used to
calculations
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain the use of containers in ssis and also their types?
List few advantages of stored procedure.
Why do you want to join software field as you have done your BE in Electronics?
Explain various On-Delete options in a DB table. Which is the default option?
What are triggers in ms sql server?
What is sql injection? How to protect against sql injection attack?
What is the difference between varchar and varchar(max) datatypes?
what are the reporting service components in SSRS?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain microsoft sql server functions?
What is the contrast between sql and mysql?
What are horizontal and vertical scaling?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is difference between cte and view?
Tell me extended events in sql server 2008?
