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.