Re: Opening cursor after closing does not seem to requery

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mberry (lionheart1159_at_yahoo.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 13:04:33 -0500

Thanks for the quick response, David. I would very much like to have a
set-based alternative, and I will attempt to scale my code down so I can
post a sample of what I am attempting to do. However, for now: is it true
that when I close a cursor (but not deallocate), then open it again, it
should re-execute the query defined in the declare statement?

Thanks again,

Michael

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:GeKdnZK1oPl3cszdRVn-gw@giganews.com...
> > parse through the table, doing stuff that could probably be done
> > easier with correlated subqueries
>
> You said it! Why don't you post the DDL and the code and maybe someone can
> give a solution that doesn't require a cursor at all. A cursor should be a
> last resort if there are set-based alternatives.
>
> --
> David Portas
> SQL Server MVP
> --
>
>

Relevant Pages

  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.server)
  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cursor for loops
    ... lots to think about there thanks david ... > I'd estimate that for most people using SQL Server at least 99.99% of data ... > manipulation can be done without a cursor. ...
    (microsoft.public.sqlserver.clients)
  • Re: Adding pre/post escape sequences to a "SAY"
    ... On Feb 20, 10:20 pm, David J Dachtera ... clears the whole screen no matter where the cursor is sitting. ...
    (comp.os.vms)