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
How can u debug your .net application?
How to count the number of objects present in a web page? How to count the number of radio buttons in a web page?
What is inproc mode in session?
Explain difference between dataset and recordset?
What is the difference between dynamic SGA and static SGA?
Which object encapsulates state or data of a user?
What is httpresponse?
what is command line compiler.what are the steps and how it is related to debugging.
What's the use of response.output.write()?
Explain how cookies work.
Securitywise What are the Enhancements in 2.0?
What is the advantage of mvc over asp.net? : Asp.Net MVC
Explain the various authentication mechanisms in asp.net.
How would you turn off cookies on one page of your website?
What is cookies cache and session?