Post reply

Done testing identity 2

  • February 28, 2019 at 12:12 am

    #100996

    Comments posted to this topic are about the item Done testing identity 2

  • February 28, 2019 at 1:07 am

    #2023167

    Good question, thanks Steve.

    ...

  • February 28, 2019 at 2:12 am

    #2023171

    Yeah, thought 0,0 or 0,1 and assumed it must be the latter.
    Oops.

  • February 28, 2019 at 2:27 am

    #2023172

    Weird thing:
    DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)
    Returns this message:

    Checking identity information: current identity value 'NULL'.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.


    So, the SELECT IDENT_CURRENT('dbo.SalesOrderHeader')
    returns 0 instead of NULL,  The INSERT uses 0.
    Now, SELECT IDENT_CURRENT('dbo.SalesOrderHeader') returns 0.

  • February 28, 2019 at 3:45 am

    #2023179

    Nice question, thanks Steve...
    i liked the wrong options, gives a real twist....

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • February 28, 2019 at 1:04 pm

    #2023235

    As documented in a number of places, the explanation "When all rows are removed from the table, the SEED is used for the identity value." is not entirely accurate.  DELETE FROM MyTable has different behavior from TRUNCATE TABLE My Table.

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

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