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

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

What is trigger ?

7 Answers   Cap Gemini, SQL,

What is constraints and its types?

0 Answers  

How to modify an existing stored procedure in ms sql server?

0 Answers  

Define full outer join in sql server joins?

0 Answers  

Do you know query execution plan?

0 Answers  

what is diffence between replicaion and logshipping?

1 Answers  

How many primary keys are possible in a table?

0 Answers  

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

What is a join and their types?

2 Answers   Challenger Financial,

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers