• You can try to Google "IDENTITY SQL Server"

    I am sure you will get lots of information which can't be provided in a single forum

    If you still have any doubts after reading the articles, feel free to revert with questions.

    You'll probably get an answer faster that way as well

    I used to call my self The Master on forums, then I entered the IT industry and realised how much I still have to learn.