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.

Explain error handling in ssis?

0 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

---

Explain the functionalities that views support?

0 Answers  

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

Why truncate is ddl?

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

Explain powershell included in sql server 2008?

0 Answers  

---

How to enable/disable indexes?

0 Answers  

---