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.

How does recursive cte works in sql server?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What is acid db?

0 Answers  

---

What is index?

1 Answers   Cap Gemini,

---

How much space does sql server 2016 take?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Explain the purpose of indexes?

0 Answers  

---

How to get the definition of a view out of the sql server?

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

Which database stores information about replication?

0 Answers  

---