Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23829 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 sqlcommand and sqldataadapter?
What is the current version of entity framework?
How to enable and disable connection pooling?
How to maintain the relation between two tables in ADO.NET?
What are the methods of XML dataset object?
What is ole used for?
Describe connection object in ado.net
How can we add relation between tables in a dataset?
What is the use of sqldatareader class?
Where is adodb dll located?
What is a datareader object?
What is the meaning of executenonquery?
What are basic methods of dataadapter?
What is dataadapter in ado.net?
What is bubbled event can you please explain?
