Differnce between Stored procedure and user defined functions?
Answer Posted / shivendra pandey
stored procedure is precomplied and not return value by
default but function compile each time and use return
statement simply.
if u r using database then use stored procedure for
pefmance n if u are working with simple pl for some
calculation go for function
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What are the ado.net connection pooling parameters?
What are the connected and disconnected modes in ado.net?
Which property is used to check whether a DataReader is closed or opened?
Compare Data Reader & Dataset in ado.net?
Define bubbled event?
What is difference between ado and other data object?
What is an ado?
Explain sqlconnection object?
What are the data access namespaces in .NET?
What is csdl entity framework?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the use of SqlCommandBuilder?
What is linq and entity framework?
What is acid in ado.net?
What is meant by executenonquery?