Posted by Tim on 10/16/07 12:32

Hi Folks,

I come from an Informix background, (pauses for the laughter to die
down), where SQL can access a hidden attribute, (ROWID), that uniquely
identifies each record in a table at that point in time. It's similar
to an IDENTITY attribute but it is not visible unless specifically
selected and the RDBMS actively re-uses the numbers as they become
vacant through deletion of records.

However it can be very useful if you are trying to unscramble static
but erroneously duplicate data rows built up due to an 'undocumented
feature' of the application software. This is the situation I find
myself in at the moment, so I was wondering if there was anything of a
similar nature hidden or undocumented in SQL Server?

I realise I could make a copy of the table and add an IDENTITY
attribute, but I'm playing with some 75,000,000 rows of data that must
all be salvaged, which complicates matters a little.

Tia, Tim

• Next in forum: Re: Can anybody help? Is there an undocumented unique record key in SQL Server?
• Prev in forum: mmsql - transact
• Thread view: Can anybody help? Is there an undocumented unique record key in SQL Server?

[Reply to this message]