identity Archives

Why can a SQL Server table not have more than one IDENTITY column?

By adminPosted on September 19, 2023

Question : Why can a SQL Server table not have more than one identity column? CREATE TABLE t(id INT IDENTITY, […]

By adminPosted on September 6, 2023

Question : I’m trying to preserve value in identity column in manner to be added later. The value should be […]

By adminPosted on September 3, 2023

Question : One of our clients is using our software with merge replication of a database on a SQL Server […]

By adminPosted on August 7, 2023

Question : In SQL Server it is so easy to write: create table #tmp ( id integer identity(1,1) primary key, […]

By adminPosted on August 7, 2023

Question : I have a PostgreSQL table with the following structure: I simply need to change the TYPE of prove_identity_id […]

By adminPosted on July 28, 2023

Question : I’m just wondering if either the spec of the implementation (PostgreSQL) provides for generating identity columns from UUIds […]

By adminPosted on July 10, 2023

Question : My impression is that each PostgreSQL table has a corresponding composite type associated with it. But it seems […]

By adminPosted on July 9, 2023

Question : I have a SQL Server 2008 server (build 10.0.5500). Earlier this week I ran this on a table […]

By adminPosted on June 29, 2023

Question : This question already has answers here: Unexpected gaps in IDENTITY column (2 answers) Closed 6 years ago. I […]

By adminPosted on May 31, 2023

Question : Is there an option in sql server to configure the default starting value(seed) of an identity column on […]