久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

如何在sql中修復錯誤獲取節(jié)點這個例子?

數(shù)據(jù)庫問題 html5模板網(wǎng)
How to Fix Error get node this example in sql?(如何在sql中修復錯誤獲取節(jié)點這個例子?)
本文介紹了如何在sql中修復錯誤獲取節(jié)點這個例子?的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！

問題描述

限時送ChatGPT賬號..

如何在sql這個例子中獲取內(nèi)部文本Divs?

考試:尺寸:14.1 英寸屏幕 (11.3"x8.4")

這是我的代碼:

聲明@htmlXML為xml = N' <div class="h-product" itemtype="http://schema.org/Product" itemscope="" ><div class="clearfix2" style="padding:0 10px"></div><div class="notification"><<div id="l_wizard_content"></div></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 t" href="/img/screens/1000/LTN141XB-L02.jpg"><img src="/img/screens/138/LTN141XB-L02.jpg" width="138" border="0" alt="宏基ASPIRE 1200 屏幕更換"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200" href="/img/screens/1000/LTN141XB-L02.jpg">Zoom [+]</a><br/></div><a target="blank" class="thickbox" title="Acer ASPIRE 1200 屏幕替換" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200 屏幕更換"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACERASPIRE 1200 替換筆記本電腦 LCD 屏幕，78.99 美元起屏幕" href="/img/screens/1000/30pinsCCFL.jpg">縮放 [+]

確保新屏幕具有相同的尺寸、分辨率、b</div></div><div class="screen_prices_container" ><div class="item_currency_selector"><h5>貨幣選擇器</h5><ul><li class="active"><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=""><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=""><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=""><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$85.99</b><div class="combo_qty_price_container">$<span >78.99</span><span class="phrase">如果購物車中的總屏幕數(shù)為 2+ </span></div><;div class="product_os_sign">缺貨</div><div class="click_on_button_below_to_be_notified_container">點擊下面的按鈕，當商品有貨時收到通知.</div><div class="通知_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="H01-14XGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||H01-14XGAmatte1||notificator_def==def5~~14.1^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~438^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||品牌==宏基"><button type="submit" value="submit" class="submitBtn_gray"><span>通知我</span></button></form></div><br/><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags canada"></i>溫哥華，BC -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags england"><;/i>英國蓋特威克 -缺貨</span></p></div><div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$85.99 USD </div><div class="right_specs_container">$116.95 CAD</div><div class="right_specs_container">&amp;英鎊;69.2 英鎊 </div><div class="right_specs_container">&amp;amp;euro;77.45 歐元 </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="通過電子郵件分享這個項目" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 筆記本液晶屏14.1 英寸屏幕 (11.3"x8.4") XGA (1024x768) 啞光 CCFL 1-Bulb&amp;amp;hash=467454">通過電子郵件分享此項目</a></div></div><div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 換屏" href="/img/screens/1000/LTN150XG_L08.jpg"><img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200 換屏"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 替換筆記本電腦液晶屏，售價 78.99 美元屏幕" href="/img/screens/1000/LTN150XG_L08.jpg">縮放 [+]</a><br/><;/div><a target="blank" class="thickbox" title="宏碁 ASPIRE 1200 換屏" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" 邊框="0" alt="宏碁 ASPIRE 1200 屏幕更換"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 更換78.99 美元起的筆記本電腦 LCD 屏幕" href="/img/screens/1000/30pinsCCFL.jpg">縮放 [+]</a><br/></div><br clear="both"><b>項目 ID:885550 </b></div><div class="screen_specs_container" ><div class="left_specs_container">兼容性:&amp;nbsp;</div><div class="right_specs_container" ><h4 >Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="替換部件類型:">替換零件類型</div><div class="right_specs_container spec_highlight">僅液晶屏&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;nbsp;</div><div class="right_specs_container" title="size">15 英寸屏幕 (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;nbsp;</div><div class="right_specs_container" title="分辨率">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="觸摸屏面板:">觸摸屏面板:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">不包括</div><div class="left_specs_container" data-filterLabel="背光類型:">背光類型:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="中間alt="?src="/images/question2.gif"/></a></div><div class="left_specs_container">視頻信號連接器:&amp;nbsp;</div><div class="right_specs_container">30 針 CCFL 屏幕&amp;amp;nbsp;[<a target="blank" class="thickbox notebooks" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">圖像</a>]</div><div class="left_specs_container">條件:&amp;amp;nbsp;</div><div class="right_specs_container">新A級+&amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container">保修:&amp;amp;nbsp;</div><div class="right_specs_container">3 年</div><div class="left_specs_container" style="color:#f00">注意:&amp;amp;nbsp;</div><divclass="right_specs_container">確保新屏幕的尺寸、分辨率和背光與舊屏幕相同！</div></div><div class="screen_prices_container" ><div class="item_currency_selector"><h5>貨幣選擇器</h5><ul><li class="active"><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=""><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=""><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=""><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$109.99</b><div class="combo_qty_price_container">$<span >99.99</span><span class="phrase">如果購物車中的總屏幕數(shù)為 2+ </span></div><;div class="product_os_sign">缺貨</div><div class="click_on_button_below_to_be_notified_container">點擊下面的按鈕，當商品恢復庫存時會收到通知.</div><div class="通知_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V01-15XGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V01-15XGAmatte1||notificator_def==def5~~15^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||品牌==宏基"><button type="submit" value="submit" class="submitBtn_gray"><span>通知我</span></button></form></div><br/><p class="country_stock"><i class="small_flags usa"></i>海特爾，華盛頓州 -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags canada"></i>溫哥華，BC -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags england"><;/i>英國蓋特威克 -缺貨</span></p></div><div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$109.99 USD </div><div class="right_specs_container">$149.59 CAD </div><div class="right_specs_container">&amp;英鎊;88.51 英鎊 </div><div class="right_specs_container">&amp;amp;euro;99.07 歐元 </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="通過電子郵件分享這個項目" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 筆記本液晶屏15 英寸屏幕 (12"x9") XGA (1024x768) 啞光 CCFL 1-Bulb&amp;amp;hash=885550">通過電子郵件分享此項目</a></div></div><div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 換屏" href="/img/screens/1000/LTN150XG_L08.jpg"><img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200 屏幕替換"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 替換筆記本電腦液晶屏，售價 78.99 美元屏幕" href="/img/screens/1000/LTN150XG_L08.jpg">縮放 [+]</a><br/></div><a target="blank" class="thickbox" title="宏碁 ASPIRE 1200 換屏" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" 邊框="0" alt="宏碁 ASPIRE 1200 屏幕更換"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 更換78.99 美元起的筆記本電腦 LCD 屏幕" href="/img/screens/1000/30pinsCCFL.jpg">縮放 [+]</a><br/></div><br clear="both"><b>項目 ID:753088 </b></div><div class="screen_specs_container" ><div class="left_specs_container">兼容性:&amp;;</div><div class="right_specs_container" ><h4 >Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="替換部件類型:">替換零件類型</div><div class="right_specs_container spec_highlight">僅液晶屏&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;nbsp;</div><div class="right_specs_container" title="size">15 英寸屏幕 (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;nbsp;</div><div class="right_specs_container" title="分辨率">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Glossy&amp;amp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="觸摸屏面板:">觸摸屏面板:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">不包括</div><div class="left_specs_container" data-filterLabel="背光類型:">背光類型:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container">視頻信號連接器:&amp;nbsp;</div><div class="right_specs_container">30 針 CCFL 屏幕&amp;amp;nbsp;[<a target="blank" class="thickbox notebooks" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">圖像</a>]</div><div class="left_specs_container">條件:&amp;amp;nbsp;</div><div class="right_specs_container">新A+&amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container">保修:&amp;amp;nbsp;</div><div class="right_specs_container">3 年</div><div class="left_specs_container" style="color:#f00">注意:&amp;amp;nbsp;</div><divclass="right_specs_container">確保新屏幕的尺寸、分辨率和背光與舊屏幕相同！</div></div><div class="screen_prices_container" ><div class="item_currency_selector"><h5>貨幣選擇器</h5><ul><li class="active"><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=""><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=""><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=""><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$99.99</b><div class="combo_qty_price_container">$<span >89.99</span><span class="phrase">如果購物車中的總屏幕數(shù)為 2+ </span></div><;div class="product_os_sign">缺貨</div><div class="click_on_button_below_to_be_notified_container">點擊下面的按鈕，當商品有貨時收到通知.</div><div class="通知_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V02-15XGAgloss1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V02-15XGAgloss1||notificator_def==def5~~15^^def6~~xga^^def7~~gls^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||品牌==宏基"><button type="submit" value="submit" class="submitBtn_gray"><span>通知我</span></button></form></div><br/><p class="country_stock"><i class="small_flags usa"></i>座位特爾，華盛頓州 -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags canada"></i>溫哥華，BC -<span class="out_of_stock">缺貨</span></p><p class="country_stock"><i class="small_flags england"><;/i>英國蓋特威克 -缺貨</span></p></div><div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$99.99 USD </div><div class="right_specs_container">$135.99 CAD </div><div class="right_specs_container">&amp;英鎊;80.47 英鎊 </div><div class="right_specs_container">&amp;amp;euro;90.06 歐元 </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="通過電子郵件分享這個項目" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 筆記本液晶屏15 英寸屏幕 (12"x9") XGA (1024x768) Glossy CCFL 1-Bulb&amp;amp;hash=753088">通過電子郵件分享該項目</a></div></div>;<div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 換屏" href="/img/screens/1000/LP150E07_A3K1.jpg"><img itemprop="image" class="u-photo" src="/img/screens/138/LP150E07_A3K1.jpg" width="138" border="0" alt="Acer ASPIRE 1200 換屏"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 替換筆記本電腦 LCD 屏幕，售價 78.99 美元屏幕" href="/img/screens/1000/LP150E07_A3K1.jpg">Zoom [+]</a><br/></div>;<a target="blank" class="thickbox" title="Acer ASPIRE 1200 換屏" href="/img/screens/1000/30pinsCCFL.jpg"><img itemprop="image" class="u-photo" src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="宏碁ASPIRE 1200換屏"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 替換筆記本電腦液晶屏，售價 78.99 美元 Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br/></div><br clear="both"><b>項目 ID:308113 </b></div><div class="screen_specs_container" ><div class="left_specs_container">兼容性:&amp;amp;nbsp;</div><div class="right_specs_container" ><h4 itemprop="model">Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="替換零件類型:">替換零件類型</div><div class="right_specs_container spec_highlight>僅液晶屏&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;nbsp;</div><div class="right_specs_container" title="size">15 英寸屏幕 (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;nbsp;</div><div class="right_specs_container" title="分辨率">SXGA (1400x1050)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="觸摸屏面板:">觸摸屏面板:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">不包括</div><div class="left_specs_container" data-filterLabel="背光類型:">背光類型:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="中間alt="?src="/images/question2.gif"/></a></div><div class="left_specs_container">視頻信號連接器:&amp;nbsp;</div><div class="right_specs_container">30 針 CCFL 屏幕&amp;amp;nbsp;[<a target="blank" class="thickbox notebooks" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">圖像</a>]</div><div class="left_specs_container">條件:&amp;amp;nbsp;</div><div class="right_specs_container">新A+&amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?"src="/images/question2.gif"/></a></div><div class="left_specs_container">保修:&amp;amp;nbsp;</div><div class="right_specs_container">3 年</div><div class="left_specs_container" style="color:#f00">注意:&amp;amp;nbsp;</div><divclass="right_specs_container">確保新屏幕的尺寸、分辨率和背光與舊屏幕相同！</div></div><div class="screen_prices_container" itemprop="offers" itemtype="http://schema.org/Offer" itemscope itemtype="http://data-vocabulary.org/Offer" ><div class="item_currency_selector"><h5>貨幣選擇器</h5><ul><li class="active"><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=""><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=""><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=""><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><div class="clearance_price_container_only">$79.99 </div><div class="clearance_word_only">CLEARANCE </div><div class="product_os_sign">缺貨</div><div class="click_on_button_below_to_be_notified_container">點擊下方按鈕通知when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V06-15-SXGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V06-15-SXGAmatte1||notificator_def==def5~~15^^def6~~sxga2^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~600^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"><button type="submit" value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></button></form></div><br/><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"></i>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"></i>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p><meta itemprop="price" content="89.99"/><meta itemprop="priceCurrency" content="USD"/><meta itemprop="itemCondition" itemtype="http://schema.org/OfferItemCondition" content="http://schema.org/NewCondition"/><meta itemprop="availability" content="OutOfStock"/></div><div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$79.99 USD </div><div class="right_specs_container">$108.79 CAD </div><div class="right_specs_container">&amp;amp;pound;64.37 GBP </div><div class="right_specs_container">&amp;amp;euro;72.05 EUR </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12"x9") SXGA (1400x1050) Matte CCFL 1-Bulb&amp;amp;hash=308113">Share this item via e-mail</a></div><meta itemprop="description" content="Acer ASPIRE 1200 Replacement Screen 15-inch Screen (12"x9")"/></div><div style="clear:both"></div></div>'

SQL:

 SELECTt.v.value('@href','nvarchar(max)') as [URL Local],t.v.value('@tppabs','nvarchar(max)') as [URL Site]FROM  @htmlXML.nodes('div/div') as t(v)

Thanks for your Tipssssssssssssssssssssssss....................................................................................................................................................................................................................................................................................................................................................................................i can in C# Start and end string select and send for sql to get inner text

解決方案

There are several things to change to the HTML before it becomes XML.
For example text like (11.3"x8.4") should be changed to (11.3&quot;x8.4&quot;) or (11.3 inch x8.4 inch)

And tags that don't have an end tag should be closed.
For example <foo bar="bla"> to <foo bar="bla"/>

For the example a shorter well formed xml.
(stackoverflow only allows up to 30000 characters)

declare @XML xml = N'<div class="h-product" itemtype="http://schema.org/Product" itemscope=""><div class="clearfix2" style="padding:0 10px"/><div class="notification"><div id="l_wizard_content"/>

<hr class="black"/><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 t" href="/img/screens/1000/LTN141XB-L02.jpg"><img src="/img/screens/138/LTN141XB-L02.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 " href="/img/screens/1000/LTN141XB-L02.jpg">Zoom [+]</a><br/>

<a target="blank" class="thickbox" title="Acer ASPIRE 1200 screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99 Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br/>

<br clear="both"/><b>Item ID: 467454</b>

<div class="screen_specs_container "><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container "><h4>Acer ASPIRE 1200</h4>

<div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight">LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">14.1-inch Screen (11.3"x8.4")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></font>

<div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]

<div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>

<div class="screen_prices_container"><div class="item_currency_selector"><h5>Currency selector</h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a>

<b class="main_price">$85.99</b><div class="combo_qty_price_container">$<span>78.99</span><span class="phrase">if total screens in cart 2+</span>

<div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="H01-14XGAmatte1"/><input type="hidden" name="section" value="notify_me"/><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||H01-14XGAmatte1||notificator_def==def5~~14.1^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~438^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"/><button type="submit" value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></表單>

<br/><p class="country_stock"><i class="small_flags usa"/>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"/>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"/>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p>

<div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$85.99 USD</div><div class="right_specs_container">$116.95 CAD</div><div class="right_specs_container">&amp;amp;pound;69.2 GBP</div><div class="right_specs_container">&amp;amp;euro;77.45 EUR</div>

<div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 14.1-inch Screen (11.3 inch x8.4 inch) XGA (1024&quot;x768&quot;) Matte CCFL 1-Bulb&amp;amp;hash=467454">Share this item via e-mail</a>

<div style="clear:both"/><hr class="black"/><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg"><img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99 Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a><br/>

<a target="blank" class="thickbox" title="Acer ASPIRE 1200 screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99 Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br/>

<br clear="both"/><b>Item ID: 885550</b>

<div class="screen_specs_container "><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container "><h4>Acer ASPIRE 1200</h4>

<div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight">LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">15-inch Screen (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></font>

<div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]

<div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>

<div class="screen_prices_container"><div class="item_currency_selector"><h5>Currency selector</h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a>

<b class="main_price">$109.99</b><div class="combo_qty_price_container">$<span>99.99</span><span class="phrase">if total screens in cart 2+</span>

<div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V01-15XGAmatte1"/><input type="hidden" name="section" value="notify_me"/><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V01-15XGAmatte1||notificator_def==def5~~15^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"/><button type="submit" value="submit" class="submitBtn_gray"/><span>NOTIFY ME</span></表單>

<br/><p class="country_stock"><i class="small_flags usa"/>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"/>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"/>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p>

<div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$109.99 USD</div><div class="right_specs_container">$149.59 CAD</div><div class="right_specs_container">&amp;amp;pound;88.51 GBP</div><div class="right_specs_container">&amp;amp;euro;99.07 EUR</div>

<div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12x9) XGA (1024x768) Matte CCFL 1-Bulb&amp;amp;hash=885550">Share this item via e-mail</a>

<div style="clear:both"/><hr class="black"/><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg"><img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99 Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a><br/>

<a target="blank" class="thickbox" title="Acer ASPIRE 1200 screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200 screen replacement"/></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99 Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br/>

<br clear="both"/><b>Item ID: 753088</b>

<div class="screen_specs_container "><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container "><h4>Acer ASPIRE 1200</h4>

<div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight">LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">15-inch Screen (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Glossy&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></font>

<div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container" style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]

<div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a>

<div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>

<div class="screen_prices_container"><div class="item_currency_selector"><h5>Currency selector</h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a>

<b class="main_price">$99.99</b><div class="combo_qty_price_container">$<span>89.99</span><span class="phrase">if total screens in cart 2+</span>

<div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><p class="country_stock"><i class="small_flags usa"/>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"/>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"/>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p>

<div class="currencies_and_shipping_cost_container"><div class="right_specs_container">$99.99 USD</div><div class="right_specs_container">$135.99 CAD</div><div class="right_specs_container">&amp;amp;pound;80.47 GBP</div><div class="right_specs_container">&amp;amp;euro;90.06 EUR</div>

<div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/>&amp;amp;nbsp;<a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12x9) XGA (1024x768) Glossy CCFL 1-Bulb&amp;amp;hash=753088">Share this item via e-mail</a>

</div>';

To get what you want from it, one should learn about the XPATH syntax.
Although SQL Server uses the XQuery, which is a superset of XPATH.

This example gets content from the <a> tags.

SELECTx.node.value('@href','nvarchar(max)') as [URL href],x.node.value('@title','nvarchar(max)') as [URL title]from @XML.nodes('//a') x(node);

how to get inner texts Divs in in sql this example?

exam: size : 14.1-inch Screen (11.3"x8.4")

this is my code:

Declare @htmlXML as xml = N' <div class="h-product" itemtype="http://schema.org/Product" itemscope="" ><div class="clearfix2" style="padding:0 10px"></div><div class="notification"><<div id="l_wizard_content"></div></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200 t" href="/img/screens/1000/LTN141XB-L02.jpg"><img   src="/img/screens/138/LTN141XB-L02.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 " href="/img/screens/1000/LTN141XB-L02.jpg">Zoom [+]</a><br /></div><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img   src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br /></div><br clear="both"><b>Item ID: 467454 </b></div><div class="screen_specs_container  " ><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container " ><h4 >Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight"> LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">14.1-inch Screen (11.3"x8.4")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container"  style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]</div><div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div></div><div class="screen_prices_container"  >                                    <div class="item_currency_selector"><h5>Currency selector                                        </h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$85.99</b><div class="combo_qty_price_container">$<span >78.99</span><span class="phrase">if total screens in cart 2+                                            </span></div><div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="H01-14XGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||H01-14XGAmatte1||notificator_def==def5~~14.1^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~438^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"><button type="submit"  value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></button></form></div><br /><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"></i>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"></i>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p></div><div class="currencies_and_shipping_cost_container">                            <div class="right_specs_container">$85.99 USD </div><div class="right_specs_container">$116.95 CAD</div><div class="right_specs_container">&amp;amp;pound;69.2 GBP                            </div><div class="right_specs_container">&amp;amp;euro;77.45 EUR                            </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/> &amp;amp;nbsp; <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 14.1-inch Screen (11.3"x8.4") XGA (1024x768) Matte CCFL 1-Bulb&amp;amp;hash=467454">Share this item via e-mail</a></div></div><div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg"><img   src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a><br /></div><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img   src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br /></div><br clear="both"><b>Item ID: 885550 </b></div><div class="screen_specs_container  " ><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container " ><h4 >Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight"> LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">15-inch Screen (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container"  style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]</div><div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div></div><div class="screen_prices_container"  >                                    <div class="item_currency_selector"><h5>Currency selector                                        </h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$109.99</b><div class="combo_qty_price_container">$<span >99.99</span><span class="phrase">if total screens in cart 2+                                            </span></div><div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V01-15XGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V01-15XGAmatte1||notificator_def==def5~~15^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"><button type="submit"  value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></button></form></div><br /><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"></i>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"></i>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p></div><div class="currencies_and_shipping_cost_container">                            <div class="right_specs_container">$109.99 USD                            </div><div class="right_specs_container">$149.59 CAD                            </div><div class="right_specs_container">&amp;amp;pound;88.51 GBP                            </div><div class="right_specs_container">&amp;amp;euro;99.07 EUR                            </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/> &amp;amp;nbsp; <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12"x9") XGA (1024x768) Matte CCFL 1-Bulb&amp;amp;hash=885550">Share this item via e-mail</a></div></div><div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg"><img   src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a><br /></div><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img   src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br /></div><br clear="both"><b>Item ID: 753088 </b></div><div class="screen_specs_container  " ><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container " ><h4 >Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight"> LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">15-inch Screen (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">XGA (1024x768)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Glossy&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container"  style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]</div><div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div></div><div class="screen_prices_container"  >                                    <div class="item_currency_selector"><h5>Currency selector                                        </h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><b class="main_price">$99.99</b><div class="combo_qty_price_container">$<span >89.99</span><span class="phrase">if total screens in cart 2+                                            </span></div><div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V02-15XGAgloss1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V02-15XGAgloss1||notificator_def==def5~~15^^def6~~xga^^def7~~gls^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"><button type="submit"  value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></button></form></div><br /><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"></i>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"></i>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p></div><div class="currencies_and_shipping_cost_container">                            <div class="right_specs_container">$99.99 USD                            </div><div class="right_specs_container">$135.99 CAD                            </div><div class="right_specs_container">&amp;amp;pound;80.47 GBP                            </div><div class="right_specs_container">&amp;amp;euro;90.06 EUR                            </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/> &amp;amp;nbsp; <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12"x9") XGA (1024x768) Glossy CCFL 1-Bulb&amp;amp;hash=753088">Share this item via e-mail</a></div></div><div style="clear:both"></div><hr class="black"><div class="screen_container"><div class="screen_image_and_zoom_cotainer"><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/LP150E07_A3K1.jpg"><img itemprop="image" class="u-photo"  src="/img/screens/138/LP150E07_A3K1.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/LP150E07_A3K1.jpg">Zoom [+]</a><br /></div><a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg"><img itemprop="image" class="u-photo"  src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement"></a><div class="screen_zoom_container"><a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a><br /></div><br clear="both"><b>Item ID: 308113 </b></div><div class="screen_specs_container  " ><div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div><div class="right_specs_container " ><h4  itemprop="model">Acer ASPIRE 1200</h4></div><div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div><div class="right_specs_container spec_highlight"> LCD Screen Only&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div><div class="right_specs_container" title="size">15-inch Screen (12"x9")&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div><div class="right_specs_container" title="resolution">SXGA (1400x1050)&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div><div class="right_specs_container" title="type"><font color="red">Matte&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></font></div><div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div><div class="right_specs_container"  style="display:none">Not Included</div><div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div><div class="right_specs_container" title="backlight-type">CCFL 1-Bulb&amp;amp;nbsp;<a class="lightbox" title="" ><img border="0" valign="middle" alt="?" src="/images/question2.gif" /></a></div><div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div><div class="right_specs_container">30 pin CCFL screen&amp;amp;nbsp;[<a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>]</div><div class="left_specs_container">Condition:&amp;amp;nbsp;</div><div class="right_specs_container">New Grade A+&amp;amp;nbsp;<a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800"><img border="0" valign="middle" alt="?" src="/images/question2.gif"/></a></div><div class="left_specs_container">Warranty:&amp;amp;nbsp;</div><div class="right_specs_container">3 Years</div><div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div><div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div></div><div class="screen_prices_container"  itemprop="offers" itemtype="http://schema.org/Offer" itemscope itemtype="http://data-vocabulary.org/Offer" >                                    <div class="item_currency_selector"><h5>Currency selector                                        </h5><ul><li class="active "><a href="?set_currency=USD" rel="nofollow">USD</a></li><li class=" "><a href="?set_currency=CAD" rel="nofollow">CAD</a></li><li class=" "><a href="?set_currency=GBP" rel="nofollow">GBP</a></li><li class=" "><a href="?set_currency=EUR" rel="nofollow">EUR</a></li></ul></div><div class="clearance_price_container_only">$79.99                                    </div><div class="clearance_word_only">CLEARANCE                                    </div><div class="product_os_sign">Out of stock</div><div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div><div class="notify_me_button_container"><form name="notify_me" action="/English/" method="post"><input type="hidden" name="notify_me" value="V06-15-SXGAmatte1"><input type="hidden" name="section" value="notify_me"><input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V06-15-SXGAmatte1||notificator_def==def5~~15^^def6~~sxga2^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~600^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer"><button type="submit"  value="submit" class="submitBtn_gray"><span>NOTIFY ME</span></button></form></div><br /><p class="country_stock"><i class="small_flags usa"></i>Seattle, WA -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags canada"></i>Vancouver, BC -<span class="out_of_stock">Out of Stock</span></p><p class="country_stock"><i class="small_flags england"></i>Gatwick, UK -<span class="out_of_stock">Out of Stock</span></p><meta itemprop="price" content="89.99"/><meta itemprop="priceCurrency" content="USD"/><meta itemprop="itemCondition" itemtype="http://schema.org/OfferItemCondition" content="http://schema.org/NewCondition"/><meta itemprop="availability" content="OutOfStock" /></div><div class="currencies_and_shipping_cost_container">                            <div class="right_specs_container">$79.99 USD                            </div><div class="right_specs_container">$108.79 CAD                            </div><div class="right_specs_container">&amp;amp;pound;64.37 GBP                            </div><div class="right_specs_container">&amp;amp;euro;72.05 EUR                            </div></div><div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right"><img src="/a_images/mail.png" alt="Share this item via e-mail" align="left"/> &amp;amp;nbsp; <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12"x9") SXGA (1400x1050) Matte CCFL 1-Bulb&amp;amp;hash=308113">Share this item via e-mail</a></div><meta itemprop="description" content="Acer ASPIRE 1200 Replacement Screen 15-inch Screen (12"x9")" /></div><div style="clear:both"></div></div>'

SQL:

 SELECT 
          t.v.value('@href','nvarchar(max)') as [URL Local],
          t.v.value('@tppabs','nvarchar(max)') as [URL Site]
  FROM  @htmlXML.nodes('div/div') as t(v)

Thanks for your Tipssssssssssssssssssssssss.................................................................................................................................................................................................................................................................................................................................................................................... i can in C# Start and end string select and send for sql to get inner text

解決方案

There are several things to change to the HTML before it becomes XML.
For example text like (11.3"x8.4") should be changed to (11.3&quot;x8.4&quot;) or (11.3 inch x8.4 inch)

And tags that don't have an end tag should be closed.
For example <foo bar="bla"> to <foo bar="bla"/>

For the example a shorter well formed xml.
(stackoverflow only allows up to 30000 characters)

declare @XML xml = N'
<div class="h-product" itemtype="http://schema.org/Product" itemscope="">
   <div class="clearfix2" style="padding:0 10px" />
   <div class="notification">
      <div id="l_wizard_content" />
   </div>
   <hr class="black" />
   <div class="screen_container">
      <div class="screen_image_and_zoom_cotainer">
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200 t" href="/img/screens/1000/LTN141XB-L02.jpg">
            <img src="/img/screens/138/LTN141XB-L02.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 " href="/img/screens/1000/LTN141XB-L02.jpg">Zoom [+]</a>
            <br />
         </div>
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg">
            <img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a>
            <br />
         </div>
         <br clear="both" />
         <b>Item ID: 467454</b>
      </div>
      <div class="screen_specs_container  ">
         <div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div>
         <div class="right_specs_container ">
            <h4>Acer ASPIRE 1200</h4>
         </div>
         <div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div>
         <div class="right_specs_container spec_highlight">
            LCD Screen Only&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="size">
            14.1-inch Screen (11.3"x8.4")&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="resolution">
            XGA (1024x768)&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="type">
            <font color="red">
               Matte&amp;amp;nbsp;
               <a class="lightbox" title="" >
                  <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
               </a>
            </font>
         </div>
         <div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div>
         <div class="right_specs_container" style="display:none">Not Included</div>
         <div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="backlight-type">
            CCFL 1-Bulb&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            30 pin CCFL screen&amp;amp;nbsp;[
            <a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>
            ]
         </div>
         <div class="left_specs_container">Condition:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            New Grade A+&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Warranty:&amp;amp;nbsp;</div>
         <div class="right_specs_container">3 Years</div>
         <div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div>
         <div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>
      </div>
      <div class="screen_prices_container">
         <div class="item_currency_selector">
            <h5>Currency selector</h5>
            <ul>
               <li class="active ">
                  <a href="?set_currency=USD" rel="nofollow">USD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=CAD" rel="nofollow">CAD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=GBP" rel="nofollow">GBP</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=EUR" rel="nofollow">EUR</a>
               </li>
            </ul>
         </div>
         <b class="main_price">$85.99</b>
         <div class="combo_qty_price_container">
            $
            <span>78.99</span>
            <span class="phrase">if total screens in cart 2+</span>
         </div>
         <div class="product_os_sign">Out of stock</div>
         <div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div>
         <div class="notify_me_button_container">
            <form name="notify_me" action="/English/" method="post">
               <input type="hidden" name="notify_me" value="H01-14XGAmatte1" />
               <input type="hidden" name="section" value="notify_me" />
               <input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||H01-14XGAmatte1||notificator_def==def5~~14.1^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~438^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer" />
               <button type="submit" value="submit" class="submitBtn_gray">
                  <span>NOTIFY ME</span>
               </button>
            </form>
         </div>
         <br />
         <p class="country_stock">
            <i class="small_flags usa" />
            Seattle, WA -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags canada" />
            Vancouver, BC -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags england" />
            Gatwick, UK -
            <span class="out_of_stock">Out of Stock</span>
         </p>
      </div>
      <div class="currencies_and_shipping_cost_container">
         <div class="right_specs_container">$85.99 USD</div>
         <div class="right_specs_container">$116.95 CAD</div>
         <div class="right_specs_container">&amp;amp;pound;69.2 GBP</div>
         <div class="right_specs_container">&amp;amp;euro;77.45 EUR</div>
      </div>
      <div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right">
         <img src="/a_images/mail.png" alt="Share this item via e-mail" align="left" />
         &amp;amp;nbsp;
         <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 14.1-inch Screen (11.3 inch x8.4 inch) XGA (1024&quot;x768&quot;) Matte CCFL 1-Bulb&amp;amp;hash=467454">Share this item via e-mail</a>
      </div>
   </div>
   <div style="clear:both" />
   <hr class="black" />
   <div class="screen_container">
      <div class="screen_image_and_zoom_cotainer">
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg">
            <img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a>
            <br />
         </div>
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg">
            <img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a>
            <br />
         </div>
         <br clear="both" />
         <b>Item ID: 885550</b>
      </div>
      <div class="screen_specs_container  ">
         <div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div>
         <div class="right_specs_container ">
            <h4>Acer ASPIRE 1200</h4>
         </div>
         <div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div>
         <div class="right_specs_container spec_highlight">
            LCD Screen Only&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="size">
            15-inch Screen (12"x9")&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="resolution">
            XGA (1024x768)&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="type">
            <font color="red">
               Matte&amp;amp;nbsp;
               <a class="lightbox" title="" >
                  <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
               </a>
            </font>
         </div>
         <div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div>
         <div class="right_specs_container" style="display:none">Not Included</div>
         <div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="backlight-type">
            CCFL 1-Bulb&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            30 pin CCFL screen&amp;amp;nbsp;[
            <a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>
            ]
         </div>
         <div class="left_specs_container">Condition:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            New Grade A+&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Warranty:&amp;amp;nbsp;</div>
         <div class="right_specs_container">3 Years</div>
         <div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div>
         <div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>
      </div>
      <div class="screen_prices_container">
         <div class="item_currency_selector">
            <h5>Currency selector</h5>
            <ul>
               <li class="active ">
                  <a href="?set_currency=USD" rel="nofollow">USD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=CAD" rel="nofollow">CAD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=GBP" rel="nofollow">GBP</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=EUR" rel="nofollow">EUR</a>
               </li>
            </ul>
         </div>
         <b class="main_price">$109.99</b>
         <div class="combo_qty_price_container">
            $
            <span>99.99</span>
            <span class="phrase">if total screens in cart 2+</span>
         </div>
         <div class="product_os_sign">Out of stock</div>
         <div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div>
         <div class="notify_me_button_container">
            <form name="notify_me" action="/English/" method="post">
               <input type="hidden" name="notify_me" value="V01-15XGAmatte1" />
               <input type="hidden" name="section" value="notify_me" />
               <input type="hidden" name="notificator_id" value="model==ASPIRE 1200||screens||V01-15XGAmatte1||notificator_def==def5~~15^^def6~~xga^^def7~~mtt^^backlight_type~~1b^^signal_connector~~1387225725^^backlight_connector~~0^^comments_for_customers~~^^ship_only_to~~0^^threeD~~^^ips~~^^touchscreen_panel~~^^mountings~~^^ac_size~~^^ac_weight~~^^ac_color~~^^shp_wght~~552^^scr_add_text~~####^^uk1~~^^uk2~~^^dsaqotw~~^^touch_screen~~^^digitizer~~^^digitizer_only~~^^glass_protector~~^^bare_screen~~^^assembly~~^^replacement_part_type~~lcd_screen||brand==Acer" />
               <button type="submit" value="submit" class="submitBtn_gray" />
               <span>NOTIFY ME</span>
            </form>
         </div>
         <br />
         <p class="country_stock">
            <i class="small_flags usa" />
            Seattle, WA -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags canada" />
            Vancouver, BC -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags england" />
            Gatwick, UK -
            <span class="out_of_stock">Out of Stock</span>
         </p>
      </div>
      <div class="currencies_and_shipping_cost_container">
         <div class="right_specs_container">$109.99 USD</div>
         <div class="right_specs_container">$149.59 CAD</div>
         <div class="right_specs_container">&amp;amp;pound;88.51 GBP</div>
         <div class="right_specs_container">&amp;amp;euro;99.07 EUR</div>
      </div>
      <div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right">
         <img src="/a_images/mail.png" alt="Share this item via e-mail" align="left" />
         &amp;amp;nbsp;
         <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12x9) XGA (1024x768) Matte CCFL 1-Bulb&amp;amp;hash=885550">Share this item via e-mail</a>
      </div>
   </div>
   <div style="clear:both" />
   <hr class="black" />
   <div class="screen_container">
      <div class="screen_image_and_zoom_cotainer">
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/LTN150XG_L08.jpg">
            <img src="/img/screens/138/LTN150XG_L08.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/LTN150XG_L08.jpg">Zoom [+]</a>
            <br />
         </div>
         <a target="blank" class="thickbox" title="Acer ASPIRE 1200  screen replacement" href="/img/screens/1000/30pinsCCFL.jpg">
            <img src="/img/screens/138/30pinsCCFL.jpg" width="138" border="0" alt="Acer ASPIRE 1200  screen replacement" />
         </a>
         <div class="screen_zoom_container">
            <a target="blank" class="thickbox" title="ACER ASPIRE 1200 REPLACEMENT LAPTOP LCD SCREEN FROM $78.99  Screen" href="/img/screens/1000/30pinsCCFL.jpg">Zoom [+]</a>
            <br />
         </div>
         <br clear="both" />
         <b>Item ID: 753088</b>
      </div>
      <div class="screen_specs_container  ">
         <div class="left_specs_container">Compatibility:&amp;amp;nbsp;</div>
         <div class="right_specs_container ">
            <h4>Acer ASPIRE 1200</h4>
         </div>
         <div class="left_specs_container" data-filterLabel="Replacement Part Type:">Replacement Part Type</div>
         <div class="right_specs_container spec_highlight">
            LCD Screen Only&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1468010881&amp;amp;height=500&amp;amp;width=800">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Size:">Size:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="size">
            15-inch Screen (12"x9")&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Resolution:">Resolution:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="resolution">
            XGA (1024x768)&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container" data-filterLabel="Surface Type:">Surface Type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="type">
            <font color="red">
               Glossy&amp;amp;nbsp;
               <a class="lightbox" title="" >
                  <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
               </a>
            </font>
         </div>
         <div class="left_specs_container" style="display:none" data-filterLabel="Touchscreen Panel:">Touchscreen Panel:&amp;amp;nbsp;</div>
         <div class="right_specs_container" style="display:none">Not Included</div>
         <div class="left_specs_container" data-filterLabel="Backlight type:">Backlight type:&amp;amp;nbsp;</div>
         <div class="right_specs_container" title="backlight-type">
            CCFL 1-Bulb&amp;amp;nbsp;
            <a class="lightbox" title="" >
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Video signal connector:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            30 pin CCFL screen&amp;amp;nbsp;[
            <a target="blank" class="thickbox laptops" title="Video Connector" href="/img/connectors/1_big/30pinsCCFL.jpg">image</a>
            ]
         </div>
         <div class="left_specs_container">Condition:&amp;amp;nbsp;</div>
         <div class="right_specs_container">
            New Grade A+&amp;amp;nbsp;
            <a class="thickbox" title="" href="/laptopscreen_viewer.php?edit_language=English&amp;amp;view_article=1243967715&amp;amp;height=500&amp;amp;width=800">
               <img border="0" valign="middle" alt="?" src="/images/question2.gif" />
            </a>
         </div>
         <div class="left_specs_container">Warranty:&amp;amp;nbsp;</div>
         <div class="right_specs_container">3 Years</div>
         <div class="left_specs_container" style="color:#f00">Note:&amp;amp;nbsp;</div>
         <div class="right_specs_container">Make sure new screen has same size, resolution, backlight as your old one!</div>
      </div>
      <div class="screen_prices_container">
         <div class="item_currency_selector">
            <h5>Currency selector</h5>
            <ul>
               <li class="active ">
                  <a href="?set_currency=USD" rel="nofollow">USD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=CAD" rel="nofollow">CAD</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=GBP" rel="nofollow">GBP</a>
               </li>
               <li class=" ">
                  <a href="?set_currency=EUR" rel="nofollow">EUR</a>
               </li>
            </ul>
         </div>
         <b class="main_price">$99.99</b>
         <div class="combo_qty_price_container">
            $
            <span>89.99</span>
            <span class="phrase">if total screens in cart 2+</span>
         </div>
         <div class="product_os_sign">Out of stock</div>
         <div class="click_on_button_below_to_be_notified_container">Click on button below to be notified when the item back in-stock.</div>
         <p class="country_stock">
            <i class="small_flags usa" />
            Seattle, WA -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags canada" />
            Vancouver, BC -
            <span class="out_of_stock">Out of Stock</span>
         </p>
         <p class="country_stock">
            <i class="small_flags england" />
            Gatwick, UK -
            <span class="out_of_stock">Out of Stock</span>
         </p>
      </div>
      <div class="currencies_and_shipping_cost_container">
         <div class="right_specs_container">$99.99 USD</div>
         <div class="right_specs_container">$135.99 CAD</div>
         <div class="right_specs_container">&amp;amp;pound;80.47 GBP</div>
         <div class="right_specs_container">&amp;amp;euro;90.06 EUR</div>
      </div>
      <div class="currencies_and_shipping_cost_container" style="background-color:#fff;line-height:1.6em;clear:right">
         <img src="/a_images/mail.png" alt="Share this item via e-mail" align="left" />
         &amp;amp;nbsp;
         <a rel="nofollow" class="email_item fake_link" href="/English/section/share_item/?b=Acer&amp;amp;m=ASPIRE 1200&amp;amp;desc=Acer ASPIRE 1200 Laptop LCD Screen 15-inch Screen (12x9) XGA (1024x768) Glossy CCFL 1-Bulb&amp;amp;hash=753088">Share this item via e-mail</a>
      </div>
   </div>
</div>';

To get what you want from it, one should learn about the XPATH syntax.
Although SQL Server uses the XQuery, which is a superset of XPATH.

This example gets content from the <a> tags.

SELECT 
x.node.value('@href','nvarchar(max)') as [URL href],
x.node.value('@title','nvarchar(max)') as [URL title]
from @XML.nodes('//a') x(node);

這篇關(guān)于如何在sql中修復錯誤獲取節(jié)點這個例子?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！

【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題，如果有圖片或者內(nèi)容侵犯了您的權(quán)益，請聯(lián)系我們刪除處理，感謝您的支持！

相關(guān)文檔推薦

What SQL Server Datatype Should I Use To Store A Byte[](我應(yīng)該使用什么 SQL Server 數(shù)據(jù)類型來存儲字節(jié) [])
Interpreting type codes in sys.objects in SQL Server(解釋 SQL Server 中 sys.objects 中的類型代碼)
Typeorm Does not return all data(Typeorm 不返回所有數(shù)據(jù))
Typeorm .loadRelationCountAndMap returns zeros(Typeorm .loadRelationCountAndMap 返回零)
How to convert #39;2016-07-01 01:12:22 PM#39; to #39;2016-07-01 13:12:22#39; hour format?(如何將“2016-07-01 01:12:22 PM轉(zhuǎn)換為“2016-07-01 13:12:22小時格式?)
MS SQL: Should ISDATE() Return quot;1quot; when Cannot Cast as Date?(MS SQL:ISDATE() 是否應(yīng)該返回“1?什么時候不能投射為日期?)
主站蜘蛛池模板： 日韩1区| 一区二区久久 | 精品久久香蕉国产线看观看亚洲 | 国产在线观看一区二区三区 | 久久一热| 超碰成人免费 | 黄色一级大片视频 | 一区二区三区免费 | 欧美在线观看网站 | 中文字幕视频三区 | 精品毛片在线观看 | 亚洲精品一级 | 亚洲欧洲日韩精品 中文字幕 | 一区欧美| 久久精品亚洲 | 男女性毛片| 欧美日韩国产高清视频 | 羞羞色影院 | 欧美国产一区二区 | 超碰97免费在线 | 欧美一区二区在线观看 | 婷婷午夜天 | 亚洲国产精品久久 | 福利精品在线观看 | 中文字字幕一区二区三区四区五区 | 久久综合一区二区 | 青青艹在线视频 | 日韩欧美在线不卡 | 国产日韩精品视频 | 欧美精品一区二区蜜桃 | 日韩高清在线观看 | 久久久久久久久久久高潮一区二区 | 国产欧美精品在线 | 日韩在线中文字幕 | 综合伊人| 国产成人99久久亚洲综合精品 | 国产精品久久久久久中文字 | 四虎影院在线观看av | 91xxx在线观看 | 国产98色在线 | 日韩 | 精品欧美激情在线观看 |