What is a cursor in SQL Server 2000 and their types?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ashish sehra
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 ? | 21 Yes | 1 No |
In SQL Server 2000 Cursors are used in stored procedures /
Functions where we have to go each record of a recordset
one by one.
Is This Answer Correct ? | 16 Yes | 6 No |
Answer / vasanthi
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;
5.DEALLOCATE cursor_name;
sample
******
DECLARE Employee_Cursor CURSOR FOR
SELECT LastName, FirstName
FROM AdventureWorks2008R2.HumanResources.vEmployee
WHERE LastName like 'B%';
OPEN Employee_Cursor;
FETCH NEXT FROM Employee_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Employee_Cursor
END;
CLOSE Employee_Cursor;
DEALLOCATE Employee_Cursor;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / arshad abbasi
Cursors allow row-by-row prcessing of the resultsets.
Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / lekhraj deshmukh
Cursor:-Cursor is used for fetching the ror by row data from
tables.
Note:-Cursor is the only datatypa that can not be used in
table creation.
When will be use cursor need to perform following steps:-
1)decalere a cursor
2) open a cursor
3)fetch the cursor
4)close the cursor
5)deallocate the cursor
Types of cursor:-
1)API cursor
2)client cursor
3)sql server cursor
Is This Answer Correct ? | 9 Yes | 10 No |
Answer / 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 |
Answer / saswat gupta
Cursor is a datatype that is not used in table. and only
used in stored Procedure/function
Is This Answer Correct ? | 1 Yes | 4 No |
What is difference in performance between insert top (n) into table and using top with insert?
What are indexes in ms sql server?
when we use function instead of procedure? plz tell me the situation with ex?
How many types of cursor type are there?
Explain about Joins?
how to select a field with firstletter as capital and remaining are small letters
What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?
What is the difference between rank and dense_rank?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
Disadvantages of the indexes?
Can we return Data from 4(more than 1) tables in stored procedure?
how to use DTS package in 2000,2005,2008 in sql server