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 is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

---

What is difference between clustered and non clustered index?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

How to use order by with union operators in ms sql server?

0 Answers  

---

What are policy management terms?

0 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---