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
Explain sqlconnection object?
How does ado.net work?
Which control of the BindingNavigator returns the current position within the data source?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is sqldatasource?
What are the advantages of oledb compared with other classes?
What is commandbuilder in ado.net?
What are the key events of sqlconnection class?
What is the use of SqlCommandBuilder?
Explain the two fundamental objects in ado.net?
What is sqldatareader in ado.net?
How to check if the Dataset has records ?
What is microsoft ado?
Which property is used to check whether a DataReader is closed or opened?
What is ado and dao?