Posted by Ralph Ganszky on 05/27/06 13:41

"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

• Next in forum: Re: Insert a record in a particular place
• Prev in forum: Oracle Server Quick Reference Guide
• Thread view: Re: Insert a record in a particular place

[Reply to this message]