Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28764 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / suraj
1)sp are pre comiled so while execution time it save time
2)sp returns many values where as function return only one
value
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is ado.net tutorial?
What do you mean by ‘batch updates’?
What is a non query?
Define Execute Reader?
What are the parameters that control most of connection pooling behaviors?
What is a dynaset in access?
What is defaultview in datatable?
What are the steps you will take to improve performance?
What does sqldatareader return?
What does executenonquery () method return?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Describe the disconnected architecture of ADO.NET’s data access model.
What is oledb driver?
What is difference between dataset and datatable?
What is the default Timeout for SqlCommand.CommandTimeout property?
