|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > sqlserver2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| junbol 2002-11-11, 6:23 am |
| In inserting records to a new table ordering the data using
two colums, first column with 6 varchar length and the
second column is 65 varchar columns, the data in the target
table are not sorted or ordered.
| |
| Brian Moran 2002-11-11, 7:23 am |
| I''m not 100% clear what your question is. Can you provide a script with
table defs and insert statements that repro your question?
However I suspect you're saying that you insert data into a table where the
insert statements are ordered. But the data is not retrieved in ordered
manner when you SELECT it.
Data returned from SQL Server 2000 is not guaranteed to be ordered unless
you use an ORDER BY statement.
--
Brian Moran
SQL Server MVP
"junbol" <lscfab@mozcom.com> wrote in message
news:dcc701c2897b$9f6f00f0$36e
f2ecf@tkmsftngxa12...
> In inserting records to a new table ordering the data using
> two colums, first column with 6 varchar length and the
> second column is 65 varchar columns, the data in the target
> table are not sorted or ordered.
|
|
|
|
|