August 4, 2005 at 12:28 pm
I was speaking to a friend about unique values in tables. He mentioned that Informix has (had) an invisible, unique identifier for each record in every table. He described it something like a row number or record number that did NOT show as a column in the table.
I’ve always used seed or GUID values in SQL Server for unique rows. I was just curious if there was some sort of equivalent in SQL Server and its proper use. (If any…)
Cheers!
Ian
August 8, 2005 at 8:00 am
This was removed by the editor as SPAM
August 8, 2005 at 2:16 pm
No, there is no such construct in SQL Server, and it is not something that is missed. A record number is a physical property and not something that we should query for. If we start telling the server how to access data instead of simply which data we want we can just as well stop using a relation DBMS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply