Posted by David Portas on 05/27/06 12:03

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
--

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

[Reply to this message]