Hi,

I have two tables like
Student
-------
sid int primarykey identity(1,1)
sname varchar(10)

SAddress
-------
Aid int Primary key identity(1,1)
Sid int foreign key
Address varchar(10)

declare @xml
set @xml='<student>
<stu>
<sid>1</sid>
<sname>rrrr</sname>
<address>newyork</address>
</stu>
</student>'


Iwant to store sid and sname in Student table next i have to store Sid of Student[Primary key] and Address in SAddress table .

thanks in advance