What is the difference between a Stored procedure and function?
- 9 Answers
- 12321 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhavi latha
stored procedute can return only one integer value.while
function can return more than one value.
we can not use select statement with storedprocedures like
select <spname> where as UDF can.
storedprocedures can not return tables.where as UDF can
return more than one tables.
we can use functions inside the stored procedure but in UDF
we can not use storedprocedures.
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
List the asp.net validation controls?
What is application session?
what are the Custom controls in asp.net?
What is routing in MVC?
Is asp net front end or backend?
Why the javascript validation not run on the asp.net button but run successfully on the html button?
what cut off mark for po's,what questions they asked for interview?
What is connection pooling and how to enable and disable connection pooling?
What are ASHX files?
Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?
What is latest version of asp.net mvc? : Asp.Net MVC
If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) In my application?
What is the difference between web.config and machine.config in ASP.NET?
What is the difference between table and query?
What is the use of worker process in asp.net?
