Thursday, June 30, 2016

What is an identity in SQL Server?

//SQL Server Auto-Increment Primary Key Field
//Example
CREATE TABLE [dbo].[DEMO]
(
SrNo [int] IDENTITY(1,1) NOT NULL,
)

auto-increment primary key field

No comments: