SQL Import

Results 1 to 2 of 2

Thread: SQL Import

  1. #1
    Thomas Lee Guest

    Default SQL Import

    When I import large text database (comma-delimited) into SQL database through SQL 7 enterprise manager, the original order is not kept. So, I loose all the proper order of data after importing into SQL database. <BR>Why is this thing happening? and how can I prevent this? <BR>Thanks a lot. <BR>tom..

  2. #2
    peterjl@austec.net.au Guest

    Default RE: SQL Import

    In any database you are not guarranteed that the records will be sorted in any order, unless you use an "Order By" clause, or if you have the table indexed. If you want your records to be sorted in the order that they are in the input source then you need to have the rows noumbered. If the source data is not numbered then you can have an auto number field in your DB table.

Posting Permissions

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