Results 1 to 4 of 4

Thread: Replication

  1. #1
    Join Date
    Feb 2003
    Location
    London
    Posts
    3

    Unanswered: Replication

    Hi,can someone help me to detect the replication of data in SQL DB tables and how to remove the replicated data.

  2. #2
    Join Date
    Feb 2003
    Posts
    15
    Do you mean duplication of data? I'm not sure what you're asking here.

  3. #3
    Join Date
    Feb 2003
    Location
    London
    Posts
    3
    Originally posted by strader
    Do you mean duplication of data? I'm not sure what you're asking here.
    Yes My friend duplication of data,can u help me please.

  4. #4
    Join Date
    Feb 2003
    Posts
    15
    Replication is a very different thing than duplication, so I had to ask.

    Can you explain the scenario a bit further, what data are you trying to detect duplicates of?

    The best situation is to avoid duplication by putting keys on columns. That might not be what you're after though

    You can write some queries though that will detect multiples of something in a table.

    Something like:

    select dupfield, count(dupfield)
    from duptable
    group by dupfield
    having count(dupfield) > 1

Posting Permissions

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