How to fetch the next row from a cursor with a "fetch" statement?



How to fetch the next row from a cursor with a "fetch" statement?..

Answer / Niranjan Kumar

"To fetch the next row from a cursor using the FETCH statement in MS SQL Server, you can use the FETCH NEXT statement. Here's an example:nnFETCH NEXT FROM myCursor INTO @var1, @var2;..."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the different types of indexes?

1 Answers   Blue Star,


what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


What are system databases into sql server (2005/2008)?

1 Answers  


how to avoid cursors? : Sql server database administration

1 Answers  


Is it possible to update the views? If yes, how, if not, why?

1 Answers  


How do I run sql server 2014?

1 Answers  


Does sql server 2000 clustering support load balancing?

1 Answers  


What does indexation mean?

1 Answers  


Where are stored procedures in sql server?

1 Answers  


What are the different subsets of sql?

0 Answers  


A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,


What is the stuff and how does it differ from the replace function?

1 Answers  


Categories