Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    Venezuela
    Posts
    3

    Unanswered: Oracle:RowId <=> Sql-Server:?

    Hi all

    I have an easy question. In Oracle I can retrieve a column named "ROWID" which returns an unique identifier of the row in the
    database. I want to have the same element in SQL Server.

    Do you know how is this handle in SQL Server ?

    Thanks in Advance

    Fabian Bonilla

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer this link is any help.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    ROWID is maintained internally and is not accessible through T-SQL.

  4. #4
    Join Date
    Feb 2004
    Location
    Venezuela
    Posts
    3
    Originally posted by rdjabarov
    ROWID is maintained internally and is not accessible through T-SQL.
    That pity: thanks for all .

  5. #5
    Join Date
    Feb 2004
    Location
    Venezuela
    Posts
    3
    Originally posted by Satya
    Refer this link is any help.
    Thanks for all

  6. #6
    Join Date
    Feb 2004
    Posts
    492
    Originally posted by rdjabarov
    ROWID is maintained internally and is not accessible through T-SQL.
    @@IDENTITY ?

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    It returns the last-inserted identity value.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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