Differnce between Stored procedure and user defined functions?
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 acid in ado.net?
What are three methods for displaying data in a syncfusion datagrid
What is the difference between dataset and datatable?
Which object is used to add relationship between two Datatables?
Describe datareader object of ado.net with example.
What is the use of sqldatareader class?
What is the difference between executequery and executenonquery?
What is the current version of entity framework?
What are the different methods by which we can populate a dataset?
What does ole stand for in excel?
What is ole db and odbc?
What is commandbuilder in ado.net?
How can I retrieve two tables of data at a time by using data reader?
What is the difference between Dataset. clone and Dataset.copy?
What is the difference between typed and untyped dataset?