can NEWID() return with the same value? RRS feed

  • Question

  • Hi lovely People!
    I want to use NEWID() in my procedure as an unique ID column.
    It runs every hour and produce about 50 lines per hour.
    What are the odds that the value under NewID() will return as the same value (for example, in a year from now)?
    Sunday, January 3, 2021 12:54 PM


  • I'd try asking for help over here.

    sql-server-transact-sql - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Marked as answer by ThomasYaris30 Sunday, January 3, 2021 1:50 PM
    Sunday, January 3, 2021 1:33 PM