|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Server-Side Cursor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Server-Side Cursor
|
|
|
| Hi Everybody,
Can anybody tell me What is Server-Side Cursor?. In what
way it is different from client-side cursor?.
tks in advance,
Sri
| |
| P. Ward 2002-11-11, 7:23 am |
| Sri
Refer to the following MSDN Article :
http://msdn.microsoft.com/library/d...-us/ado270/htm/
mdconcursorlocationsignificanc
e.asp
In a nutshell, when using a client side cursor the resources of the client
are being used to manage the recordset, where as a server side cursor uses
the servers resource to manage the recordset.
"Sri" <madhavan.srinivasan@citigroup.com> wrote in message
news:da0e01c28952$9aae8f50$36e
f2ecf@tkmsftngxa12...
> Hi Everybody,
>
> Can anybody tell me What is Server-Side Cursor?. In what
> way it is different from client-side cursor?.
>
> tks in advance,
> Sri
| |
| Brian Moran 2002-11-11, 7:23 am |
| You should also consider that 'server side cursors' use often used as a term
to describe ANSI cursours created using the DECLARE CURSOR TSQL syntax.
--
Brian Moran
SQL Server MVP
"P. Ward" <pwardy@bigpond.com> wrote in message
news:Ob4PY#XiCHA.2456@tkmsftngp12...
> Sri
>
> Refer to the following MSDN Article :
>
>
>
http://msdn.microsoft.com/library/d...-us/ado270/htm/
> mdconcursorlocationsignificanc
e.asp
>
> In a nutshell, when using a client side cursor the resources of the client
> are being used to manage the recordset, where as a server side cursor uses
> the servers resource to manage the recordset.
>
> "Sri" <madhavan.srinivasan@citigroup.com> wrote in message
> news:da0e01c28952$9aae8f50$36e
f2ecf@tkmsftngxa12...
> > Hi Everybody,
> >
> > Can anybody tell me What is Server-Side Cursor?. In what
> > way it is different from client-side cursor?.
> >
> > tks in advance,
> > Sri
>
>
|
|
|
|
|