Server Side Cursor

[dcstech]

Can anyone explain to me, simply, what a server side cursor is?

Thanks
DCSTech

[Landley]

This is my understanding ...

A cursor is used to define and keep track of a position within a recordset.
If the cursor is server side, when your code iterates through a recordset,
all the work is done at the server's end and its results is sent to the
client. The benefits of this is that the clients machine will not be tied
up performing this database action. If the cursor is client side, the
result set is brought across to the client, for the client to handle the
iteration.

Landers

"dcstech" <dc*****@discussions.microsoft.com> wrote in message
news:4B**********************************@microsof t.com...

Can anyone explain to me, simply, what a server side cursor is?

Thanks
DCSTech