Post reply

Identifying row id in a table

  • April 7, 2004 at 8:32 am

    #108031

    Can anyone please let me know if there a table which doesnt have a unique identifier  how is it possible to identify any particular row from that table. ex like in oracle we can use rowid to identify a row something similar in sql too?

    any help will be greatly appreciated.

    TIA

  • April 7, 2004 at 2:25 pm

    #502056

    There is no ROWID() in SQL Server. If you haven't got a *unique* column, I'd say your're pretty much out of luck. However, you can still create an artificial sequential numbering by adding a numeric column to that table and defining the IDENTITY property for it.

    What do you want this for?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 8, 2004 at 1:01 am

    #502083

    If your problem is trying to delete one of two identical rows, do the following:

    SET ROWCOUNT 1

    DELETE FROM table_name

    WHERE condition1,condtion2,....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply