Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #466
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Gene Wirchenko <genew@ocis.net> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: BCP ordering? |
| Date | Fri, 17 Jun 2011 12:15:43 -0700 |
| Organization | A noiseless patient Spider |
| Lines | 16 |
| Message-ID | <pr9nv6l9k461keslbq1c7l6clovvl013oa@4ax.com> (permalink) |
| References | <8d9b7401-207c-4c90-bac1-c99f98783b3b@r2g2000vbj.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Transfer-Encoding | 7bit |
| Injection-Info | mx04.eternal-september.org; posting-host="7Qrvczazr82YckO5XW8Vtw"; logging-data="2560"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+MHyHDaao1PNJS+P37lOR5EHdElAbMOPg=" |
| X-Newsreader | Forte Agent 4.2/32.1118 |
| Cancel-Lock | sha1:MyHYEmJfljzYMPVLThoNmF/jHGg= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:466 |
Show key headers only | 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
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