Differnce between Stored procedure and user defined functions?
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
What is oledb connection?
Explain sqlconnection object?
Is ado.net dead?
What are all the different authentication techniques used to connect to MS SQL Server?
What is ado and rdo?
What is bubbled event?
Explain what are acid properties?
What are the key features of ado.net?
What is ado.net and its architecture?
What is data reader in ado.net?
What is Serialization in .NET? what are the types of Serialization?
Does entity framework use ado.net?
What is the return type of executescalar?
What is openrowset?
Which namespaces are used for data access?