Groups > comp.databases.ms-sqlserver > #858

Re: Cursor Question

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From	Travis Crow <noreply@invalid.org>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Cursor Question
Date	Fri, 2 Dec 2011 12:03:48 +0000 (UTC)
Organization	Aioe.org NNTP Server
Lines	11
Message-ID	<jbaer4$ogt$1@speranza.aioe.org> (permalink)
References	<jbabbk$g59$1@speranza.aioe.org> <Xns9FAF80203B027Yazorman@127.0.0.1>
NNTP-Posting-Host	CSjod2juaAwkjN0Czk2TZw.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Pan/0.133 (House of Butterflies)
X-Notice	Filtered by postfilter v. 0.8.2
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:858

Show key headers only | View raw

On Fri, 02 Dec 2011 12:35:43 +0100, Erland Sommarskog wrote:

> With a static cursor, the result set of the cursor is saved to a temp
> table and the rows are served from this table. I believe this happens at
> OPEN time, but you could easily test to find out.

Thanks. I have tested this and it appears to be at OPEN time.

-- 
Travis Crow

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Cursor Question Travis Crow <noreply@invalid.org> - 2011-12-02 11:04 +0000
  Re: Cursor Question Erland Sommarskog <esquel@sommarskog.se> - 2011-12-02 12:35 +0100
    Re: Cursor Question Travis Crow <noreply@invalid.org> - 2011-12-02 12:03 +0000

csiph-web