Results 1 to 2 of 2

Thread: what is equalent of oracle rowid ? in sql ser.

  1. #1
    Nellai Guest

    what is equalent of oracle rowid ? in sql ser.

    Hi guys,

    how to identify the rowid values.i am having one table without primarykey how to remove repeated data ?

    Thanks

  2. #2
    Kenneth Wilhelmsson Guest

    what is equalent of oracle rowid ? in sql ser. (reply)

    select <column>
    from <table>
    group by <column>
    having count(*) > 1

    will give you all <column> that repeat themselves.
    One other option is to create a clustered index with ignore_dup_rows option.
    (check in BOL for details)
    There are some other techniques to remove dupes, depending on exactly what you want to achieve. ... see other post on the same subject.

    /Kenneth


    ------------
    Nellai at 5/12/99 4:48:47 AM

    Hi guys,

    how to identify the rowid values.i am having one table without primarykey how to remove repeated data ?

    Thanks

Posting Permissions

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