Differnce between Stored procedure and user defined functions?
Answer Posted / suresh jayaraman
Procedure-is also called Proc
proc-parsing resloving organizing compiling
stored Procedure once compiled and run many times,when we
create procedure,that procedure is stored in executeplan,so
no need to recompile.
but fuction every time compiling and running.
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
How can we serialize the dataset object?
What connected data?
What are the main differences between classic ado and ado.net?
How do you update a dataset in ado.net?
Which is faster ado.net or linq?
What provider ado.net use by default? Explain the role of data provider in ado.net?
How to creating a SqlCommand Object?
What is the difference between Dataset. clone and Dataset.copy?
Can you explain how to enable and disable connection pooling?
What is the difference between Datareader and Dataset?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
How to add a check box or a dropdown list to a column in a datagrid?
Why is stored procedure used in ado.net?
Define bubbled event?
What is ado in agriculture?