IDENTITY PROPERTY

HI guys,

hope u guys are doing well. Today i am going to introduce a new concept called IDENTITY PROPERTY.

IDENTITY PROPERTY means that name itself indicating providing the identity sequence of numbers automatically to a table column in the database.

Example for IDENTITY PROPERTY:

Method 1 : giving the identity property for a table.

create table example_tab

(

emp_id int primary key identity(100,1), --100 is the seed and 1 is incremental

emp_name nvarchar(30) not null

)

Thanks for visiting my blog.