IDENTITY Property

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.

5 (7)

You rated this post out of 5. Change rating

2020-05-21

7,874 reads

Blogs

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Data Governance: The Invisible AI Accelerator

By

Introduction Do you remember the effort of tidying up your BI and reporting systems,...

Read the latest Blogs

Forums

Moving On After a Technology Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving On After a Technology...

Configuring Maintenance Plans in SQL Server

By Kenneth Igiri

Comments posted to this topic are about the item Configuring Maintenance Plans in SQL...

Counting Bits III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Bits III

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers