Kenneth Igiri

The IDENTITY Column Property

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

3,504 reads

Blogs

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

What happens if your SQL Server editions are out of support? – a MinionWare snippet

By

The more your SQL Server is out of date, the more things become vulnerable,...

Daily Coping 3 Jun 2020

By

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

Read the latest Blogs

Forums

Daily 3 Coping

By Steve Jones - SSC Editor

Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/

Daily Coping 2 Jun 2020

By Steve Jones - SSC Editor

Today’s tip is to think about how your actions make a difference for others....

Buy crack Cocaine online oliviachemstore.com | Heroin for sale online

By paulkay

Buy MDMA Molly Online, Pure Heroin for sale online, Ketamine For Sale Online, Buy...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers