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

Cursor Question

From	Travis Crow <noreply@invalid.org>
Newsgroups	comp.databases.ms-sqlserver
Subject	Cursor Question
Date	2011-12-02 11:04 +0000
Organization	Aioe.org NNTP Server
Message-ID	<jbabbk$g59$1@speranza.aioe.org> (permalink)

Show all headers | View raw

If I declare a cursor with a "where clause", is that "where clause" 
evaluated when I declare the cursor or when I open it?

I'd assume the latter but I just wanted to make sure.

(in anticipation to a certain question/comment, yes I do try to avoid 
cursors at all times)

-- 
Travis Crow

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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