Identity

• bala-275691

  SSC Rookie

  Points: 36

  More actions

  November 9, 2005 at 11:51 pm

  #67150

  in oracle we select the rowid by using this query

  select rowid from tablename

  which query i have to use for sql server.my aim is to get the unique value

   

  regards

  Balasubramanian

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  November 11, 2005 at 6:44 am

  #603403

  Rowid is not exposed in SQL Server.  You will have to use the primary key column(s) of the table.