Tag Archives: Identity columns
-
How can I use the identity column, without knowing identity column’s name.
Leave a commentMay 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 -
DBA Myths: Is an identity column always unique, in order, and without gaps?
6November 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 -
Identity in a SELECT
4December 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 -
Bulk insert and an identity column
1December 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 -
The identity column, the insert and the linked server.
4June 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 -
Adding Identity to an existing column
2June 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 -
How do I change the increment of an identity column?
7April 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