Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Post Unanswered: unique index question

    Hi, I have a table: Email as my primary key, unique index, ignore duplicate key

    I want to keep the sequence order in this table. But everytime I import new data into this table, the sequence order has been changed.

    My question: how can I keep the sequence while importing new data, which has a unique index primary key.

    I will certainly appreicate your help!

  2. #2
    Join Date
    Jul 2002
    Village, MD
    Use clustered index on your field.

Posting Permissions

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