Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28109 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
Describe datareader object of ado.net with example.
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is an example of ordinal data?
Which is faster datareader or dataadapter?
How to find the given query is optimised one or not?
Define table relations?
What are the namespaces used in ado.net for data access?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
List the 4 common ado.net namespaces?
Explain the different row versions available in table?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
Why do we serialize data?
What is the difference between Optimistic and Pessimistic locking?
Explain the difference in record set and dataset?
Explain the overview of ado.net architecture?
