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,407 reads

Blogs

Connect With More Clients: Our Partner Directory Has Arrived

By

The partner directory connects your agency with new customers.

Can You See Who Forced a Plan

By

I had an excellent group of people in Gothenburg Sweden when I taught there...

Monday Monitor Tips–Finding CUs for My Instance

By

How can I quickly get a CU patch for a system that’s out of...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

SSISDB: finding executions from an Execute Package Task

By Lowell

I am trying to find usage and non-usage of package sin my ssisdb catalog....

workaround for problems that cant be try caught

By stan

hi a peer of mine recalls an error in an edi app that often...

Visit the forum

Question of the Day

Trigger Order III

I have created these triggers in SQL Server 2022: 

CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT
AS
PRINT 'one'
GO
CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT
AS
PRINT 'two'
GO
I want to be sure that the trigger with "1" runs first. I decide to run this: 
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'
What happens?

See possible answers