RIAS
asked on
Reset IDENTITY(1,1) column
Hello,
How to set a column which is [Ref] [int] IDENTITY(1,1) NOT NULL to 1 . I tried to delete all rows in the table but still
when I insert a row in the table , theRef value is 33.
Regards
How to set a column which is [Ref] [int] IDENTITY(1,1) NOT NULL to 1 . I tried to delete all rows in the table but still
when I insert a row in the table , theRef value is 33.
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Mark!!!
ASKER
Mark,
I know I have to answer your previous question. Temporarily I have just removed the date columns as pressed for time , but I am gonna get back to you this week.
Hope you understand a developers situation.:>
I really appreciate your time and help.
I know I have to answer your previous question. Temporarily I have just removed the date columns as pressed for time , but I am gonna get back to you this week.
Hope you understand a developers situation.:>
I really appreciate your time and help.
No worries, and totally understand :)
ASKER
Thanks!
ASKER