Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-07 : 08:19:54
|
| Boon Ping writes "Hi When using BCP command to upload a text file into a table, the order seems to be different after each command and I could never have the same order I saw in the text file. Any of you observe this before? Is it a bug in SQL 2000? I just upgrade my server from 7.0. I never observed such behaviour in previous version. Thanks in advance all to you all Gurus" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-11-07 : 09:52:00
|
| I can understand the concept of the order of records in a text file ... but that is different than what? If you mean "different from the order of the data in the table", I'm curious to know how you know what the order of the data is in the table?Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-07 : 12:10:59
|
| Boon Ping, if you want to maintain a particular order, then use a query for bcp and specify an ORDER BY clause.Tara |
|
|
|
|
|
|
BCP Command