In the SQL Server, Is it possible to move from a record to next record as VB Code

[accesser2003]

How can I move from record to the next record as what we do in the VB Code by using movenext and moveprevious.

How can I achieve this in the SQL Server code.

Thanks,

 

[georgedwilkinson]

Pat, as usual, is right. You might want to read up on cursors in SQL Server.