Post reply

cursor

  • September 28, 2008 at 12:50 pm

    #382875

    how to make cursor in sql server 2005?

  • September 28, 2008 at 1:04 pm

    #878195

    john_izzy (9/28/2008)

    how to make cursor in sql server 2005?

    Why do you need a cursor? Unless you're doing certain types of admin tasks (which are often one object at a time) there are better ways to work in SQL than with a cursor.

    That said, look at DECLARE CURSOR in books online

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 28, 2008 at 6:51 pm

    #878225

    The OP must like porkchops...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply