sequence

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

3,371 reads

Blogs

Using WAITFOR to Test Slow Code–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Power BI Monthly Digest – May 2020

By

This month we will likely have two releases of the Power BI Desktop. In...

Three big reasons T-SQL still beats the GUI – a MinionWare snippet

By

We like code better than mouse clicks for three basic reasons: T-SQL lets you...

Read the latest Blogs

Forums

The Basics of Using a Sequence as a Table Default

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Basics of Using a...

Inlining Scalar UDFs

By Greg Larsen

Comments posted to this topic are about the item Inlining Scalar UDFs

Question About Microsoft Data Migration and the MAP

By imani_technology

Hi, has anyone ever transformed the raw output generated by Microsoft Assessment and Planning...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers