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

    Unanswered: Update a Duplicate Record

    Hi everybody,

    I have 2 fields in a table.

    Table Name--- StudentDetail

    Name Address

    Saju Kerala
    Balaji Bangalore
    Raj Kumar Tamilnadu
    Saju Kerala

    I want to Update one of the duplicate row as I don't have any unique id column. So can anybody update one of the the duplicate record without using any id or altering any column.

    I am waiting for your reply.................


    Saju S.V

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Without a unique key you are heading for disaster
    set rowcount 1
    update StudentDetail
    set Name='Sajusv' where name='Saju'

Posting Permissions

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