Home Forums SQL Server 2005 SQL Server 2005 Strategies Random rows generator: RE: Random rows generator:

  • March 2, 2014 at 11:14 am

    #1693382

    KoldCoffee (3/1/2014)

    Hi RBarryYoung,

    Can you please explain use of 0x7fffffff ?

    I don't know why they did that in Books Online except, maybe, that it's easier to remember than 2147483647, which is the maximum postive number that an INT can contain.

    --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)