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 - 2005-04-01 : 08:10:09
|
| Ashish writes "Hi All, I am new for SQL Server. The case is I am simply copying a table to another having the same structure. There is no PK or any other constraints. I am using the simple statementSELECT * INTO DEST_TAB FROM SRC_TABIt is copying the data. Then I convert it into CSV file. While comparing the both CSV file, it is not matching. Some rows are shifted upwards, some downwards, some are same. If I have copied the one table to another then the row order should be same. Is there any option through which I can control it and get the table having the same row order as original.Any help is appreciated.Thanks in advance.RegardsAshish" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-01 : 08:11:20
|
| Row order means nothing in a relational database. If two tables contain the same data, they are the same. |
 |
|
|
|
|
|
Ordering of table data