Home Forums SQL Server 2008 T-SQL (SS2K8) NEWID() - How does it work? RE: NEWID() - How does it work?

  • February 25, 2013 at 4:50 pm

    #1590976

    Lynn Pettis (2/22/2013)

    Jeff Moden (2/22/2013)

    Lynn Pettis (2/22/2013)

    I haven't tried, but are you sure you can convert a uniqueidentifier to a bigint?

    Yes, but not directly.

    SELECT CAST(CAST(NEWID() AS BINARY(16)) AS BIGINT)

    Cool. Learned something tonight. Now, I should probably get some sleep since I have 4 soccer games to ref tomorrow at the Sunbelt Tournament; which I am calling the Frozen Belt since it snowed, it is only supposed to get to 40 or so tomorrow (colder on Sunday), But hey, soccer season is starting!!

    Ah, crud. Sorry, Lynn. Not sure what I was thinking. Michael is correct. The code I posted seems to work but is technically incorrect because a GUID is 16 bytes and a BIGINT is only 8. It's the old 2 pound bag thing.

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