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
Define bubbled event?
Which object is used to add relationship between two Datatables?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How will you fill the gridview by using datatable object at runtime?
What is the difference between data reader and data adapter?
Explain how can we load multiple tables in to dataset?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the usage of the dataset object in ado.net?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
How would you connect to database using .NET?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What does ole stand for in excel?
What is data access pattern?
What is microsoft ado?
Which parameter of ConnectionString is used to specify the name of the database?