Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2004 @ 14:44:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Jonathan White
Applied Predictive Technologies

	<Prev	Next>		<<First	<Prev	Next>	Last>>