Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23786 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
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 a column variable?
What is the difference between ado.net and oledb?
Explain the overview of ado.net architecture?
What is ado.net in mvc?
What is read only and forward only in ado.net?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Which is faster dataset or datareader?
Is ado.net dead?
What is difference between executequery and executeupdate?
What is the executescalar method?
Why do we use sqldataadapter?
What is a dataview?
What is ado full form?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What are the ado.net components?
