You are here: Re: BULK INSERT into table with identity column? « MsSQL Server « IT news, forums, messages
Re: BULK INSERT into table with identity column?

Posted by M Bourgon on 09/02/06 13:27

> Even if you want the identity values to be generated for you, the column
> still has to be in the file if you don't use a format file.

Aha.

> What I don't really remember is whether you actually can trust the
> IDENTITY values to match the order the rows appear in the file. If you
> want to play safe, you may want to write a program that reads the file
> and adds a line number on each line in the file.

Okay, thanks again, Erland. I was afraid of that.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация