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 happens if an ASP.NET server control with event-handling routines is missing from its definition?
How long should a session id be?
What are the built-in objects in asp.net?
What is asp.net mvc? : asp.net mvc
What is asp.net futures?
What is the difference between client-side and server-side validations in webpages?
Define caching.
What is the use of HttpHandlers? When to use this?
What is a master page and what does it do?
What is a session government?
What is applicatio domain?
What is side-by-side execution? Can two applications, one using a private assembly and other using a shared assembly, be stated as side-by-side executables?
What are navigation controls? How many navigation controls are there in ASP.NET 4.0?
What is form submit?
Does web services support data reader like pom project?