 By default the seed and increment are both 1.Create Table Contacts (


or


Create Table Contacts (
GO
Alter Table Contacts Add ContactID int identity(1, 1)


It is often useful or necessary to know what identity value was generated by an INSERT command.Microsoft SQL Server provides several functions to do this