Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28801 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 executenonquery ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is the difference between OLEDB Provider and SqlClient?
Why is ADO.NET serialization slower than ADO ?
What is ado.net code?
Explain ODP.net
What are the Data providers in ADO.Net?
What is ado.net tutorial?
What are the data access namespaces in .NET?
What is the use of connection object in ado.net?
Describe connection object in ado.net
Explain the various objects in dataset.
What is a datagridview?
How to pass values into a datatable?
What do you mean by ‘batch updates’?
