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

[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,

 

[Pat Hartman]

You are more likely to get an answer at a TSQL or PHP site or one that helps with stored procedures.

 

[georgedwilkinson]

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