Interested to Buy Any Domain ? << Click Here >> for more details...
What is a cursor in SQL Server 2000 and their types?
- 8 Answers
- 18912 Views
- I also Faced
- E-Mail Answers
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 |
How to write a query with a full outer join in ms sql server?
What is the data type of time?
What is a trigger what are the advantages of trigger?
What is the correct order of the logical query processing phases?
How do I setup a sql server database?
What is raiseerror? What is raiseerror?
How can we remove orphan records from a table?
What is the standby server?
Can we write ddl in trigger?
What is the parse query button used for?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is a sql join?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
