Answer Posted / vishesh tomar
There are three types of Stored Procedure in sql server
1. User Defined
2. System Defined
2. Temprary Stored Procedure
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Which is the best method to get two values from the database?
Define the data provider classes that is supported by ado.net?
How can we serialize the dataset object?
What is microsoft ado.net?
What is disconnected architecture in ado.net?
Explain the differences between oledb sql server, oledbdotnet provider?
What is a data control clerk?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What is linq and entity framework?
What is ado or jdbc?
differences between ADO and ADO.NET
What are the core objects of ADO.NET?
How do you update a dataset in ado.net and how do you update database through dataset?
Explain ado.net features?