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.

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

How to make remote connection in database?

1 Answers  

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1 Answers   CSC, IBM,

---

Is trigger fired implicitely?

2 Answers  

---

What is stored procedures?

1 Answers  

---

Do you know how to make remote connection in database?

1 Answers  

---

How to return the second 5 rows in ms sql server?

1 Answers  

---

How to add more data to the testing table in ms sql server?

1 Answers  

---

Is foreign key a primary key?

1 Answers  

---

How to drop existing indexes in ms sql server?

1 Answers  

---

What is Lock table in SQL?

1 Answers   Wipro,

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---