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 connected data?
What is ole used for?
What is full form of ado?
Difference between sqlcommand and sqlcommandbuilder?
What are three methods for displaying data in a syncfusion datagrid
What is a dynaset in access?
What is the provider being used to access oracle database?
What is DataRowCollection?
Which name space is used to get assembly details?
What are the data access namespaces in .NET?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
Why edit is not possible in repeater?
What do you mean by ‘batch updates’?
How to add an aggregate column?