Archives of the TeradataForum

Message Posted: Thu, 02 Jun 2011 @ 05:56:23 GMT

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

There is a difference if you are doing a multi-row operation such as INSERT/SELECT.

With SET, completely duplicate rows will be quietly eliminated; with MULTISET, any duplicates would cause a uniqueness violation on the PI.

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