Re: Sp_CursorOpen,Fetch,Close
From: Alin Sinpalean (alin_at_earthling.net)
Date: 01/28/05
- Next message: Carb Simien [MSFT]: "RE: The DBMS returned an unspecified error."
- Previous message: Joe Weinstein: "Re: Sp_CursorOpen,Fetch,Close"
- In reply to: chinn: "Re: Sp_CursorOpen,Fetch,Close"
- Messages sorted by: [ date ] [ thread ]
Date: 28 Jan 2005 15:36:34 -0800
chinn wrote:
> Can Somebody explain what this actually means..
>
> exec sp_cursorfetch 180176529, 2, 1, 256
This should help:
http://jtds.sourceforge.net/apiCursors.html#_sp_cursorfetch
(It means "fetch from the cursor with handle 180176529 the next 256
rows". The rownum 1 has no effect with fetch type 2 == next.)
Alin.
- Next message: Carb Simien [MSFT]: "RE: The DBMS returned an unspecified error."
- Previous message: Joe Weinstein: "Re: Sp_CursorOpen,Fetch,Close"
- In reply to: chinn: "Re: Sp_CursorOpen,Fetch,Close"
- Messages sorted by: [ date ] [ thread ]
