Results 1 to 3 of 3

Thread: Is there any T-SQL to search for duplicates ? (*** SOLVED ***)

Threaded View

  1. Jun 13th, 2004, 10:25 PM #1
    Wen Lie
    Wen Lie is offline

    Thread Starter
    Fanatic Member Wen Lie's Avatar
    Join Date
    Jul 1999
    Location
    Singapore
    Posts
    524

    Unhappy Is there any T-SQL to search for duplicates ? (*** SOLVED ***)

    Hi...

    Let's say like this... I have an old database in .DBF format. I transfer the database to SQL Server using DTS. Result of DTS is the table(s) from .DBF with no Primary Key.

    When I need to set up the PK (primary key), SQL returns error, and said something likes "Duplicate key found for record .... and ..."

    My question is :
    before I setup the PK, can I find which record has its duplicate(s) by using T-SQL at Query Analyzer ???

    FYI : I'm using SQL Server 2K
    Last edited by Wen Lie; Jun 13th, 2004 at 10:42 PM.
    Regards,
    [-w-]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width