What is a cursor in SQL Server 2000 and their types?
Answer Posted / kokila
When will be use cursor need to perform following steps:-
1. DECLARE CURSOR
2. OPEN
3. FETCH
4. @@FETCH_STATUS
5. CLOSE
6. DEALLOCATE
1.DECLARE cursor_name CURSOR FOR SELECT_statement;
2.OPEN cursor_name;
3.FETCH cursor_name INTO variable list;
5.CLOSE cursor_name;
6.DEALLOCATE cursor_name;
Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are relationships and mention different types of relationships in the dbms
What is the name of reporting services config file and what’s it’s used for?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is data block and how to define data block size?
Explain how many normalization forms?
Explain the Ways to improve the performance of a sql azure database?
explain different types of joins? : Sql server database administration
what information is maintained within the msdb database? : Sql server administration
How to remove duplicate rows from table?
How to loop through result set objects using odbc_fetch_row()?
what is nonclustered index
What are pages and extents? : SQL Server Architecture
What are the types of dml?
What is 2nf example?