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.

State the difference between union and union all?

0 Answers  

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

What happens on checkpoint?

0 Answers  

---

What is a data source file?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

What are built in functions?

0 Answers  

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,

---

What is normalization of database? What are its benefits?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---