home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,367 of 19,505   
   Gene Wirchenko to esquel@sommarskog.se   
   Re: BCP ordering?   
   17 Jun 11 15:25:52   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca