You have Sql Table Which Having for Example 20 Records.
And Identity also 20. Now you want insert new Record with
Identity 100 then you pass 99 in below function as Parameter
and Table Name and Reseed .
DBCC CHECKIDENT (TableName, reseed, 99)