Answer / praveen singh

A cursor is a set of rows together with a pointer that
identifies a current row.

In other word, Cursor is a database object used by
applications to manipulate data in a set on a row-by-row
basis, its like recordset in the ASP and visual basic.


DECLARE @fName varchar(50), @lName varchar(50)

DECLARE cursorName CURSOR -- Declare cursor

LOCAL SCROLL STATIC

FOR

Select firstName, lastName FROM myTable

OPEN cursorName -- open the cursor

FETCH NEXT FROM cursorName

INTO @fName, @lName

PRINT @fName + ' ' + @lName -- print the name

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM cursorName

INTO @fName, @lName

PRINT @fName + ' ' + @lName -- print the name

END



CLOSE cursorName -- close the cursor

DEALLOCATE cursorName -- Deallocate the cursor

Answer / ramesh

when we execute any query its return result set. directly
to work on result set we use cursors.

but right now no one is supporting cursors.

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

What are cursors and when they are useful?

0 Answers  

---

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

0 Answers  

---

What is the use of set nocount on/off statement?

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

What do we have to check in database testing?

0 Answers  

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

Why are views required in the sql server or in any other database?

0 Answers  

---

What are the components of sql server service broker?

0 Answers  

---

What are security principals used in sql server 2005?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---