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 the difference between connected and disconnected environment?
What are the methods of XML dataset object?
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?
Do you use stored procedure in ado.net?
What is ado and rdo?
Define bubbled event?
How to add a javaScript function in a datagrid?
What is aggregating data ?
What is ado.net objects?
What is csdl entity framework?
Explain the namespaces in which .net has the data functionality class.
Why is stored procedure used in ado.net?
What is the use of SqlCommandBuilder?
How to check if the Dataset has records ?
What are the data providers used in ado.net