I don't think this is possible as i've tried testing but just wanted to make sure.
Can you use a variable within the Identity Function? ie., Identity(int, @.start, 1)
If you can't is there another function to perform what I am trying to do?
Basically I would like to imitate an identity column to avoid mass updates and re-create tables that had an identity column.
Any help / advice would be greatly appreciated.
If I understood correctly, you want the identity value to start from a certain number and then increment by 1?You have some options for that:
Set the initial number of the identity column to the desired. E.g. start from 2000.
No comments:
Post a Comment