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 !!!
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 :)
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 .
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.