|
|
Posted by Peter on 10/02/66 11:49
SQL Server does not have a functionality to insert a record in a particular
place in a table.
If you are talking about a clustered index then
1. You are not talking about the functionality 'table' but about an
implementation detail.
2. The function of a clustered index is to speed up queries, not to insert
in a specific position.
It makes no sense to insert a record in a particular place. It makes sense
to:
1. get records in a order by using order by
2. speed up querys by using a clustered index.
It is wrong to expect sorted records in the result set of a query without
using a order by, even if there is a clustered index. Functional spoken, the
concept table (also in SQL Server) has no order.
Peter
"Ralph Ganszky" <rg@web.de> wrote in message
news:e59adc$kug$01$1@news.t-online.com...
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
> news:1148720603.539232.327650@g10g2000cwb.googlegroups.com...
>> surya wrote:
>>> i have a table name is HH table
>>> it has two columns 'hhno' and hhname'
>>> HH tabele
>>> hhno hhname
>>> 100 suresh
>>> 101 baba
>>> 103 ram
>>> i want to insert a one record(102 , chandra) in HH table between
>>> (101,baba) and( 103 ,ram).
>>> how can i insert them please help ,me thanks
>>
>> Like this:
>>
>> INSERT INTO hhtable (hhno, hhname)
>> (102 , 'chandra');
>>
>> SELECT hhno, hhname
>> FROM hhtable
>> ORDER BY hhno ;
>>
>> A table doesn't have any order. Only the results of a SELECT statement
>> can be sorted.
>>
>> --
>> 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
>> --
>>
>
> I think you can have an ordered table in SQL Server if you are using a
> clustering index.
>
> Regards
> Ralph
>
Navigation:
[Reply to this message]
|