All Forums Database
SAP 73 posts Joined 08/14
21 Sep 2014
Unique Identifier in SQL Server - Equivalent in Teradata ?

Hi All ,
Can anyone help me with Equivalent in Teradata for Unique Identifier in SQL Server ? Though i can accomodate the values with VARCHAR datatype but when i need unique values to be generated . What will i do in that case ?
 
Thanks in advance !!!
 

SAP
Raja_KT 1246 posts Joined 07/09
21 Sep 2014

will this help you select ROW_NUMBER() OVER (ORDER BY fieldnames) , a.* from your_table a;
I am not able to follow when you say "I can accomodate ........"
Teradata  do have identity column, but I prefer using query :)

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SAP 73 posts Joined 08/14
21 Sep 2014

Thanks Raja !!! 
I shall explain in detail :- 
Actually we are migrating from SQL Server to teradata . In SQL Server Unique identifier is a datatype used in DDLs . This creates a global unique number [ something like this : DF GH 44 YI ...] using MAC address . There cannot be any unique number for a record than this in whole universe , [[they say]] :) :O . Now data in SQL serevr is in this format .
When i migrate , i can accomodate those records in VARCHAR and use use ROW_NUMBER but do we have any concept like Unique Identifier in Teradata ??? I have to find a equivalent in teradata which should very much near to the functionality .
 
 

SAP

Raja_KT 1246 posts Joined 07/09
21 Sep 2014

I am not  a SQL server person :). Teradata's unique identity column is different. However, if you know the functionality you can think of a UDF. That is my thought.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SAP 73 posts Joined 08/14
21 Sep 2014

Thanks Raja !!!

SAP

You must sign in to leave a comment.