What is the difference between a Stored procedure and function?
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
What is application variable in asp.net?
what is AutoEventWireUp and what is the use of This property explain in details?
Can you explain how ASP.NET application life cycle and page life cycle events fire?
Is asp.net different from asp? If yes, explain how?
Suppose you want an asp.net function (client side) executed on the mouseover event of a button. Where do you add an event handler?
What is the benefit of WebAPI over WCF?
how to debug web services on consumer side?
What is the current version of asp.net?
Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?
What is the procedure to create the environment for asp.net? : asp.net mvc
Is it possible to write code in many languages in one asp.net project?
Explain client side state management system.
What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC
Difference between overriding and overloading?
What is the significance of ASP.NET routing?