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
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is data relation?
How would you connect to a database by using .NET?
how we can fire event in databound coulm in datagfrid withot using button?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What are the 3 major types of connection objects in ado.net?
What is ole word?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What is microsoft ole db provider for sql server?
What is the default provider in ado.net?
What is ado.net object model?
What is bubbled event?
Explain what is datagrid with an example?
Explain the difference between ado and ado.net?
What is ado control?