Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28107 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sharad kulat
Store Procedure Is first tme complie and make the
Execution plan & next time proc just call plan .so its get
execute fast.In case Function compile every request.
function & Store procedure return not only single but also
number of value .
function return number of value useing return type table.
You Can use Function with select ,case Statement ,same
thing can not do through Store procedure.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is two way data binding android?
What are the advantages and drawbacks of using ado.net?
What do you mean by ‘batch updates’?
Explain the difference in an abstract class and an interface?
What are the core objects of ADO.NET?
What is the difference between ado.net and entity framework?
Explain how can we load multiple tables in to dataset?
What are the advantages of oledb compared with other classes?
What do you mean by performing asynchronous operation using command object?
Describe datareader object of ado.net with example.
Which is the feature of ado.net?
What is row state?
How to identify the updated rows in a dataset?
What is the maximum pool size in ado.net connection string?
What is a sqldataadapter?
