Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28800 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / ranjanimanuel
1.UDF can't use a nondeterministic functions such as Getdate
(),RAND() where as StoreProcedure cn use such a functions.
2.UDF must return a value or a single resultset . Store
Procedure can return a value or even multiple resultsets,
but doesn't have to
3. UDF can be used in anywhere sql statements like
where/having/Select sections where as store procedure
cannot be.
4.UDFs that return table can be treated as another rowset.
This can be used in JOINS with other table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between dataset and datatable?
What are the benefits of ADO.NET?
What are the usages of the command object in ado.net?
What are basic methods of dataadapter?
Explain the architecture of ado.net?
Describe the disconnected architecture of ADO.NET’s data access model.
How to creating a SqlCommand Object?
How do you update database through dataset?
What are the features of ado.net?
What are the methods of XML dataset object?
What is ado.net code?
What are the advantages of ado.net?
What is the difference between dataset and datatable?
Explain the differences between oledb sql server, oledbdotnet provider?
What is execute reader in ado.net?
