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 - 2002-05-08 : 09:33:35
|
| Vinod Phutane writes "I want to import my text file in SQL Server 2000, in the sequence as it appears in the text file. I have a text file with no delimeters or field seperators. When I upload this file into my SQL Server 2000 database, the file gets uploaded improperly. The rows are not inserted in the sequence in SQL database the way they appear in the text file. The table has no key or any index.Appreciate for your quick helpThanksVinod" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-08 : 10:33:07
|
| unless an order (key or clustered index) is explicitly defined, there is nothing to define the 'sequence' of either the natural table order or the order of the resultset you are using in you query to display the contents of the table.<O> |
 |
|
|
|
|
|
SQL Server 2000 text file import