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.

Which virtual table does a trigger use?

3 Answers  

---

What is Schema in Database?

1 Answers   Cap Gemini,

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

What are the different ways you can create databases in sql server?

0 Answers  

---

Why we use trigger in sql server with example?

0 Answers  

---

How do I uninstall sql server 2014?

0 Answers  

---

How to connect ms access to sql servers through odbc?

0 Answers  

---

What are tables in sql server?

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

What is implicit mode in sql server?

0 Answers  

---

What is transaction server auto commit?

0 Answers  

---