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 many languages are supported by .NET at present time?
What is the difference between “Web.config” and “Machine.Config”?
What is full trust in asp.net?
What are Master Pages in ASP.NET? or What is a Master Page?
How many types of sessions in asp.net?
What does occur first in ASP.Net, Authentication or Authorization?
What are custom controls?
What is the question mark in a url?
What is a Cookie? Where is it used in ASP.NET?
How many types of cache are there?
What are the differences between the response.write() and response.output.write()?
Explain server-side scripting and client-side scripting.
Can more than one person use the same login?
Does web services support data reader like pom project?
What are the properties of the eventargs argument when capturing keyboard events?