Archives of the TeradataForum
Message Posted: Wed, 21 Apr 2004 @ 14:44:22 GMT
| Subj: || || Re: Retrieving the generated identity value |
| From: || || Jonathan White |
Thanks for the reply. What about in the real world case where a2 is not going to be unique? A more fleshed out example would be a products
table where the unique productID is generated from an identity, saving the application developer from dealing with unique id generation. The MS
SQL equivelant would be select @@identity.
Applied Predictive Technologies