IDENTITY Property

The IDENTITY Column Property

  • Article

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.

5 (7)

2020-05-21

4,172 reads

Blogs

Using Write-Debug

By

I wrote a post about PoSh output recently, noting that in general we ought...

T-SQL Tuesday Retrospective #002: A Puzzling Situation

By

For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...

Daily Coping 28 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Stored Proc with OPENJSON: How to determine insert or update?

By Goalie35

This is my 1st attempt at openjson & I'm trying to setup a stored...

product version result

By mtz676

SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to...

Login to SQL Server cross domain AD Group user

By Papote

Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers