Post reply

will any one help

  • July 7, 2011 at 10:45 am

    #241133

    Will any one help with this functionRAND(CHECKSUM(NEWID()). I googled it but i cant find exact solution and explanation.

  • July 7, 2011 at 10:54 am

    #1349844

    This is a method to help get a random result set.

    Do you have questions around how to use it or something else?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 7, 2011 at 10:55 am

    #1349846

    just break it down into it's peices:

    SELECT

    NEWID(),--returns a varchar-ish something like D93D157E-3749-4A26-8410-859B237CE7FF

    CHECKSUM(NEWID()), --returns a bigint like 1339413509 or -1323543251

    ABS(CHECKSUM(NEWID())), --makes sure it's positive like 1585842432

    RAND(CHECKSUM(NEWID())) --returns a value between 0 and 1 like 0.917917441450155

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 7, 2011 at 10:57 am

    #1349848

    It's used to get random numbers. It's usually used for data generation for simple tests (like scenarios for blog posts)

    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

  • July 7, 2011 at 11:08 am

    #1349860

    RAND - http://msdn.microsoft.com/en-us/library/ms177610.aspx

    CHECKSUM - http://msdn.microsoft.com/en-us/library/ms189788.aspx

    NEWID - http://msdn.microsoft.com/en-us/library/ms190348.aspx

Viewing 5 posts - 1 through 4 (of 4 total)

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