Identity Option in Server Management stuido express

(2 posts) (2 voices)

Activate e-mail notification in your profile settings to get updates. [Help ?]

Tags:

sandee
Member

Hi,

For ID Value, first time when i run the query it is counting from 1 to n..

Next time when i run the console once again and execute the query, my id Value is not counting from 1, It is counting from n(previously where it is stopped) and incrementing thereafter...

How to resolve this one ??

Thanks

Posted 1 year ago #
Arun Mallick
Key Master

Hi,
check the below post for more information regarding Identity property on a column and its various features.
http://www.sqllion.com/2011/08/identity-in-sql/

--Arun

Posted 1 year ago #