SQL Server: (L7) How to use the DBCC CheckIDENT command and reseed identity column

In this video, I show you have to override how the identity column behaves when you are performing an insert statement. I also show you how to RESEED, an identity column.

I show you how to use the DBCC command: set IDENTITY_INSERT table_name on;
How to use the DBCC CheckIDENT command and reseed identity column

How to reset an identity column
How to reseed an identity column
dbcc checkident

#softwareNuggets, #sqlServer, #datatype, #intDatatype, #DBCC, #identityColumn, #identity

[blixstaa]

Thank you for teaching me how to reseed an identity column

[ViralShores]

Please Reseed identity column using C#