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 an ado?
Explain how to create dynamic gridview?
Is bulk insert faster than insert?
What are the Features and disadvantages of dataset
Which object of ado contains datarow datacolumn collection?
What is a data control clerk?
Which is faster entity framework or ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is difference between datareader and dataadapter?
Which method is used to sort the data in ADO.Net?
What is the difference between DataReader and DataSet in ADO.NET?
What is a serialized object?
What is datatable in ado.net?
differences between ADO and ADO.NET
What are the core objects of ADO.NET?