Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 29288 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 full form of ado?
What is the difference between oledb sql server and oledbdotnet provider?
What is isolation?
What are the objects of ado.net?
What is two way data binding android?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Explain the two fundamental objects in ado.net?
Which object is used to add relationship between two Datatables?
What are the different layers of ado.net?
Explain executenonquery?
How to creating a SqlCommand Object?
What is the difference between data reader and data adapter?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is difference between dataset and datatable?
What is the functionality of data provider in ado.net?
