SQL Server: (L6) How to use the IDENTITY Column Property on an Integer Data Type.

See how to declare an Identity Column on an integer column. How to perform insert statement on table that has an identity column.

Add the IDENTITY property to an existing column in sql server

How to use IDENTITY Column Property on an Integer Data Type

Show you how to change the seed and incrementor values of the identity property.

Learn a trick that can delay a hacker from looping over all your data using a sequential identity value.

#softwareNuggets, #identityColumn,#autoNumber, @softwareNuggets

[blixstaa]

Thank you for showing how to use IDENTITY on a int data type