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 is serialization and de-serialization in .net?
How can we serialize the dataset object?
What are the key events of sqlconnection class?
What are the advantages using ado.net?
What is a dynaset in access?
What is ambient transaction?
What is the difference between ado.net and entity framework?
What is executequery?
What is ole word?
What is connected architecture in ado.net?
Define executenonquery?
What is difference between executequery and executeupdate?
Describe ado.net object model in detail.
What do you mean by performing asynchronous operation using command object?
Explain executenonquery?