Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28839 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 the difference between the clone() and copy() methods of the dataset class?
Explain the dataadapter class in ado.net?
What is the difference between ADO and ADO.Net?
What is the difference between ado.net and entity framework?
What is DataRowCollection?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is the difference between Optimistic and Pessimistic locking?
What is datasource in ado.net?
What are the uses of Stored Procedure?
How to pass multiple tables in datasets simultaneously?
Define connection string?
What is ole db and odbc?
Explain the difference between an ado.net dataset and an ado recordset?
Define atomicity?
What is the namespaces being used to access oracle database?
