Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28636 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
How is it possible to get 2 tables of data at a time by using data reader?
What is the DataTableCollection?
What is the difference between data reader and data adapter?
Why do we serialize data?
What is ado or jdbc?
What are the parameters that control most of connection pooling behaviours?
What is dataadapter in ado.net?
How do you find the count of records in a dataset?
How do you update a dataset in ado.net and how do you update database through dataset?
Explain the difference in record set and dataset?
What is the difference in an abstract class and an interface?
How to work with disconnected data - the dataset and sqldataadapter?
What are the benefits of ADO.NET?
Explain executenonquery?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
