Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 29312 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 are the namespaces used in ADO.Net to connect to a database?
What is difference between Dataview and Datatable?
Explain the namespaces in which .net has the data functionality class.
Explain the advantage of ADO.Net?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is dataset object? Explain the various objects in dataset.
How to retrieve the user id which is provided while windows authentication?
Explain the architecture of ado.net?
Which ado.net object is very fast in getting data from the database?
What are the rules to implement connection pooling?
What is ado.net object model?
What are the core objects of ADO.NET?
What is ado rdo dao in visual basic?
Explain the role of data provider in ado.net?
What is partial class?
