Unique ID, without an ID column

Hi,

How can I assign or retrieve a unique ID from a msSQL table where there isn't a unique column.

Is there a hidden 'raw id' i can retrieve from msSQL for each record?

I'm not allowed to change the current database at all, but the developers who created it managed to use it without Unique IDs.... which doesn't help me coming from a mySQL background where UID's are kind of mandatory.

Thanks

No. You need a primary key or unique constraint. Tell that to the developers.



There is no difference between Mysql and Mssql with regard to this.

I've gotten a little further, I've discovered how do find out the primary key. (in this case there are 3)



True, the SQL is the same. I'll rephrase. I'm used to doing things in a certain way with mySQL, where as in this case someone else has designed the database without my beloved unique ID's.