Friday, March 9, 2012

Identity Function

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