What is a cursor in SQL Server 2000 and their types?
Answer Posted / sd
Cursors allow row-by-row prcessing of the resultsets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven
| Is This Answer Correct ? | 30 Yes | 7 No |
Post New Answer View All Answers
How many levels of sp nesting is possible?
What is the difference between a function and a trigger?
Ways to improve the performance of a SQL Azure Database?
Differentiate between a primary key and a unique key.
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Write a SQL query to delete a table?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Define normalisation?
Explain what is analysis service repository?
How do you delete a data source?
How to create new tables with "select ... Into" statements in ms sql server?
What structure can you implement for the database to speed up table reads?
What is a dbms wizard?
What is a transact-sql statement?
What is the difference between value type and reference type?