ROW ID in Oracle - What is same in MSSQL

• dbamark

  SSCommitted

  Points: 1694

  More actions

  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

• ckempste

  SSCoach

  Points: 17983

  More actions

  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"

• dbamark

  SSCommitted

  Points: 1694

  More actions

  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!!!