July 10, 2003 at 11:30 am
I have used ROW ID in Oracle, is there an equivalent in SQL Server? Also, how can it be accessed if available? Thanks in advance!
Mark
July 10, 2003 at 7:17 pm
Hi there
There are no virtual columns, such as rowid, that you can access "easily". The row is located via a file:page:slot combo, all of which is not quickly accessible in a nice/neat query as in oracle.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 11, 2003 at 5:15 am
Thanks, Chris. I was having a hard time finding anything on this. I have a programmer here who used to code Oracle and asked if there was something similar. I was familiar with Oracle's rowid (having been an Oracle DBA), but was dumbfounded to find anything other than GUID, which didn't quite seem the same!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply