Home Forums SQL Server 2008 T-SQL (SS2K8) How do i update an identity column with identity value? RE: How do i update an identity column with identity value?

  • January 29, 2015 at 1:03 pm

    #1774162

    David Burrows (1/29/2015)

    dwain.c (1/28/2015)

    David - that's a very clever alternative!

    Thank you :blush:

    It is very annoying that you can use ALTER COLUMN to do everything except add or remove IDENTITY 🙁

    True, and that you can't update it. But you have to remember what an IDENTITY value is -- it's a physical insert count. Thus, it's not consistent with that data to allow it to be updated. It's technically not consistent to allow it to be inserted either, but I'm glad MS lets us slide by on that one :-).

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.