Posted by Erland Sommarskog on 05/27/06 11:24

surya (suryaitha@gmail.com) writes:
> 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

Just as you would insert any other row:

INSERT HH(hhno, hhnmae)
VALUES (102, chandra)

Then again, one can say that you can't because "between" does not make
any sense in this context. Tables are unordered sets of rows.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Insert a record in a particular place
• Prev in forum: Insert a record in a particular place
• Thread view: Re: Insert a record in a particular place

[Reply to this message]