From: genew@ocis.net   
      
   On Fri, 17 Jun 2011 23:35:12 +0200, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >> On Fri, 10 Jun 2011 06:18:07 -0700 (PDT), blindsey   
   >> wrote:   
   >>>Can I generate an identity column when importing using BCP that will   
   >>>sequence by the physical order of the records?   
   >>   
   >>      What physical order?   
   >>   
   >>      A file can be in chunks all over a volume.  If you mean within   
   >> the file, the DBMS could write a row anywhere it has space to do so.   
   >>   
   >>      You have to define an order if you want one.   
   >   
   >Gene, he is talking about reading a text file into SQL Server with   
   >the BCP command. Text files typically have a physical order. Well,   
   >if you want to talk disk blocks, that's really a logical order. But   
   >ordered they are.   
      
        Not my point.  1) He is then expecting them to be in order in the   
   table.  2) He gives SELECTs with no ORDER BY clauses and expects an   
   order.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)