|
Posted by David Portas on 05/27/06 15:17
Ralph Ganszky wrote:
>
> I think you can have an ordered table in SQL Server if you are using a
> clustering index.
>
> Regards
> Ralph
You cannot. That is to say, a table with a clustered index is still not
logically ordered.
The OP asked how to insert a row between other rows. Although a
clustered index might achieve something like that at the page level a
clustered index doesn't really answer the original question - there is
no way to INSERT rows between each other. The only reliable way to get
ordered results from a table is to use ORDER BY when you query the
table.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|