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 is partial class?
What is the difference between executenonquery () and executescalar ()?
How do you implement locking concept for dataset?
What is ado.net full form?
How to store data in memory?
What is a serialized object?
What is maximum pool size in ado.net connection string?
Explain the difference in record set and dataset?
Describe datareader object of ado.net with example.
What is the default timeout specified for "sqlcommand.commandtimeout" property?
differences between ADO and ADO.NET
What is microsoft ado?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
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 ado in agriculture?