Answer / sd

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven

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

Answer / rajiv rohilla

In SQL Server 2000 Cursors are used in stored procedures /
Functions where we have to go each record of a recordset
one by one.

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;

Answer / arshad abbasi

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven

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

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

Answer / saswat gupta

Cursor is a datatype that is not used in table. and only
used in stored Procedure/function

How can you find out how many rows returned in a cursor?

0 Answers  

What is the full meaning of dml?

0 Answers  

Can we hide the definition of a stored procedure from a use?

0 Answers  

What extended events?

0 Answers  

What’s the use of custom fields in report?

0 Answers  

What is de-normalization and what are some of the examples of it?

0 Answers  

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

How to convert a table data in XML format in sql server?

0 Answers  

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

What does select 1 mean?

0 Answers