sequence

SQLServerCentral Article

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.

(7)

You rated this post out of 5. Change rating

2020-05-21

8,544 reads

Blogs

T-SQL Tuesday #200 - I Bet It's Bad if I See...

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Azure – HorizonDB

By

As Open Source – PostgreSQL and AI is a growing and powerful DB system,...

A New Chapter: Why I Made the Move from Dayforce to ESO

By

A New Chapter: Why I Made the Move from Dayforce to ESO Over the...

Read the latest Blogs

Forums

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Moving the Error Log

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving the Error Log

A Security and AI Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Security and AI Fail

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers