Differnce between Stored procedure and user defined functions?
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 are the 3 major types of connection objects in ado.net?
Define executenonquery?
What is Dataset Object?
Which property is used to check whether a DataReader is closed or opened?
Which is better entity framework or ado.net?
What is variable view?
What are three methods for displaying data in a syncfusion datagrid
What is difference between executenonquery and executequery?
How is entity framework different from ado.net?
What are advantages of microsoft-provided data provider classes in ado.net?
Which database is the ado.net?
What is ado.net objects?
What is the functionality of data provider in ado.net?
How to retrieve the user id which is provided while windows authentication?
Explain the advantage of ADO.Net?