Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 21:41:19 GMT

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

Hey Nitin

Thnaks for enquiring . Tell me abt it .

Not really used c-sum but we have a solution with row_number(). But the problem is that some business users are using MSACCESS as the front end so they can simply add or delete or update table from Access directly without having to write queries in Teradata .

Is it a good idea first of all to define an customer_number primary key field based on identity column .

Secondly if people make copies of this table and come back to insert /update or recreate the table they Are loosing the original numbers.

Rgds

Vikas

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