Post reply

ROW ID in Oracle - What is same in MSSQL

  • July 10, 2003 at 11:30 am

    #81947

    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

    #464996

    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

    http://www.chriskempster.com

    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

    #465049

    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