How to insert xml value into database using sql2008

My xml is:
<Root>
<Hotelid>1009</Hotelid>
<Photo>
<div class="e"> <div><Url>/RXLImages/GTA/LIS-RES4hotel_Exterior_1.jpg</Url></div> </div> <div class="e"> <div>  <Width>360</Width></div> </div> <div class="e"> <div>  <Height>240</Height></div> </div> <div ...