Differnce between Stored procedure and user defined functions?
Answer Posted / suresh mandala
1>Stored Procedure returns morethan one value where as
Function returns only one value
2>stored procedure we may use return statement.. but in
userdefined function we should use return statement
3>stored procedure is precomplied but function compile each
time we call it.
If u have any quieries ask me ,i will try
| Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
What is difference in record set and dataset?
What are the usages of the command object in ado.net?
How do you update database through dataset?
Why edit is not possible in repeater?
List the 4 common ado.net namespaces?
What are the steps you will take to improve performance?
What is ado.net architecture?
What is command class in ado.net?
What is ado.net connection?
What are the namespaces used in ado.net for data access?
Compare Data Reader & Dataset in ado.net?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is difference between Dataview and Datatable?
What is the role of clr?
Explain ado.net features?