Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23787 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
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
How can we serialize the dataset object?
What is commandbuilder in ado.net?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What is data relation?
Is ado.net an orm?
Does executenonquery return a value?
What is connection string?
how can implement dropdownlist in particular of dataset when try to update?
Which object of ado contains datarow datacolumn collection?
How do you connect to sql server database without using sqlclient?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the executescalar method?
What are two important objects of ADO.Net?
What are the Data providers in ADO.Net?
Define atomicity?
