If you meant @@IDENTITY, it works only after an INSERT operation. If we use this, it will be a double work as we will have to do INSERT first, then do an UPDATE.
We usually look for less overhead methods.
Wll, I am not sure whether I got correctly what you meant. Sorry.
Praveen V Nair, PMP
Tech Blog | PM Blog