Groups > comp.databases.ms-sqlserver > #466

Re: BCP ordering?

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: BCP ordering?
Date	2011-06-17 12:15 -0700
Organization	A noiseless patient Spider
Message-ID	<pr9nv6l9k461keslbq1c7l6clovvl013oa@4ax.com> (permalink)
References	<8d9b7401-207c-4c90-bac1-c99f98783b3b@r2g2000vbj.googlegroups.com>

Show all headers | View raw

On Fri, 10 Jun 2011 06:18:07 -0700 (PDT), blindsey
<blindsey@dsicdi.com> 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.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

BCP ordering? blindsey <blindsey@dsicdi.com> - 2011-06-10 06:18 -0700
  Re: BCP ordering? Erland Sommarskog <esquel@sommarskog.se> - 2011-06-11 00:05 +0200
  Re: BCP ordering? stukie <stukieh@gmail.com> - 2011-06-17 06:53 +0000
  Re: BCP ordering? Gene Wirchenko <genew@ocis.net> - 2011-06-17 12:15 -0700
    Re: BCP ordering? Erland Sommarskog <esquel@sommarskog.se> - 2011-06-17 23:35 +0200
      Re: BCP ordering? Gene Wirchenko <genew@ocis.net> - 2011-06-17 15:25 -0700
        Re: BCP ordering? Erland Sommarskog <esquel@sommarskog.se> - 2011-06-18 11:29 +0200

csiph-web