Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: Travis Crow Newsgroups: comp.databases.ms-sqlserver Subject: Cursor Question Date: Fri, 2 Dec 2011 11:04:20 +0000 (UTC) Organization: Aioe.org NNTP Server Lines: 11 Message-ID: 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:856 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