Q:

I need help understanding Identity in sql

IDENTITY [ (seed , increment) ]
What does seed do? 
I can't seem to find the answer on google.

A:

The seed param is the value that is used for the very first row loaded into the table.Think of seed as the starting value, and increment as the amount to go up by.The default val for seed an increment is (1,1) resulting in identities of 1,2,3,...   If you specified (5,1) you would get identities 5,6,7,...
Source: https://msdn.microsoft.com/en-us/library/ms186775.aspx

