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
Is a dll file an executable?
Differentiate between namespace and assembly.
What is the used of "ispostback" property?
What are the advantages of passport authentication?
How does asp page work?
Explain how is a property designated as read-only?
What is difference between viewstate and session state in javascript?
How do I open an ashx file in windows 7?
if i want to give an alert message like "try after sometime" to a web page which is being seen by other person.if a web page is not seen by anyone then it should display otherwise it show a display a message stating that other person is viewing so try after some time........how can i implement this.
Explain the path instructions in xaml?
what is command line compiler.what are the steps and how it is related to debugging.
Can you explain autopostback?
What are the Difference between asp.net and asp ?
Who can consume WebAPI?
What’s the use of “GLOBAL.ASAX” file?