|
|
-
|
|
When IDENTITY columns are added to existing tables, how is a particular record assigned an IDENTITY value?...
|
|
-
|
|
IDENTITY values work great when inserting records into a table. But, can IDENTITY columns be added to existing tables where records already exist in the table? If yes, in what order will the IDENTITY values be assigned?...
|
|
-
|
|
When one thinks of an incremental number, a series of positive numbers comes to mind. Is this true for IDENTITY columns too? Can IDENTITY numbers, their SEED and INCREMENT values be negative?...
|
|
-
|
|
Is it really required that the SEED value for an IDENTITY column start at 1? Similarly, can we assume that INCREMENT will also always be 1? Today’s post addresses these myths....
|
|
-
|
|
A myth around IDENTITY columns is that they cannot have duplicate values, i.e. they are UNIQUE values. IDENTITY values are generated by SQL Server, but they do not have to be unique. They can have duplicate values under many situations – for example explicit inserts and identity reset....
|
|
-
|
|
A myth around IDENTITY columns is that values cannot be inserted explicitly into IDENTITY columns. Not only can IDENTITY columns accept explicit inserts via the IDENTITY_INSERT option, this is one of the most used methods when working with replication and on data migrations....
|
|
-
|
|
One of the myths around IDENTITY columns is that IDENTITY columns cannot have holes or “gaps” in the column values. In this post, I present a simple test that busts this myth once and for all....
|
|
-
|
|
This series attempts to explore one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns....
|
|
-
|
|
Starting today, I present a series that explores one of the most frequently used, but perhaps least understood feature of Microsoft SQL Server - IDENTITY columns. Today's post presents an introduction to the IDENTITY column and lists the general rules around it....
|
|
-
|
|
How do you ensure that a given database belongs to your product? This post presents two of my most used approaches....
|
|