Differnce between Stored procedure and user defined functions?
- 17 Answers
- 23830 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
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 difference between sqldatareader and sqldataadapter?
Can datareader hold data from multiple tables?
What are all the different authentication techniques used to connect to MS SQL Server?
What we do with the object of ado.net dataset after using it?
Explain the role of data provider in ado.net?
What is executequery?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is difference between Dataview and Datatable?
What is the difference between DataReader and DataSet in ADO.NET?
What is fill method in ado.net?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is sqldatareader in ado.net?
What is Data view?
What is an ado?
How to store data in memory?
