Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    76

    Unanswered: RowId in SQL server 2000

    Hi Champs,

    Is there anyway to get row id of row stored in specific table in sql server 2000 database similar to Oracle?

    Thanks in advance,
    Jai

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Nope...in 2005 they have it

    You could add an identity column to your row

    Even in Oracle it's not really an "id" for that row.

    The row id is not always assigned to the same row.

    It could be different every time

    Identity would always be the same.

    Why?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •