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
What is the difference between dataset and datatable?
What is the use of SqlCommand object?
What is a sqldataadapter?
What is oledb driver?
Explain how to find the given query is optimised one or not?
What is ado and rdo?
What are the features of ado.net?
How will you fill the gridview by using datatable object at runtime?
What is data relation in ado.net?
What is an example of ordinal data?
How can we load multiple tables in to dataset?
Is bulk insert faster than insert?
What is a column variable?
What is ado rdo dao in visual basic?
Describe the disconnected architecture of ADO.NET’s data access model.