Difference between Function and Stored Procedure?
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
What is a data source file?
How to convert binary strings into integers in ms sql server?
List the different index configurations possible for a table?
What is system stored procedures?
what exactly sql injuction.how to overcome.....
Does group by sort data?
What is difference between index and primary key?
How to trouble shoot if unable to connect SQL Server
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is a rownum?
what is hash nonclustered index
Explain primary key in sql server?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Do you know query execution plan?
How use inner join in sql server?