Tag Archives: Identity columns

  1. How can I use the identity column, without knowing identity column’s name.

    Leave a comment

    May 12, 2022 by Kenneth Fisher

    One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The …
    Continue reading

  2. DBA Myths: Is an identity column always unique, in order, and without gaps?


    November 20, 2019 by Kenneth Fisher

    Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost …
    Continue reading

  3. Identity in a SELECT


    December 19, 2018 by Kenneth Fisher

    Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
    Continue reading

  4. Bulk insert and an identity column


    December 12, 2018 by Kenneth Fisher

    TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file …
    Continue reading

  5. The identity column, the insert and the linked server.


    June 14, 2018 by Kenneth Fisher

    tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
    Continue reading

  6. Adding Identity to an existing column


    June 19, 2017 by Kenneth Fisher

    A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
    Continue reading

  7. How do I change the increment of an identity column?


    April 5, 2017 by Kenneth Fisher

    Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013