ÇóÒ»×Ö·û´®½ØÈ¡sql - MS-SQL Server / »ù´¡Àà

ijһ×ֶθñʽÈçÏÂ
<ul><li><a href='/20_00_1.html'>ʯÅÆÇÅ</a></li><li><a href='/20_0-1.html'>¹ãÖÝÌìºÓ¹«½»³¡</a></li><li><a href='/20_0_4_0152_1.html'>ÌìºÓÄÏ</a></li></ul>

ÇóÒ»sqlɾ³ýÆäÖеĴúÂëÊ£ÏÂ
ʯÅÆÇÅ£»¹ãÖÝÌìºÓ¹«½»³¡£»ÌìºÓÄÏ

лл

---

###

---

»¹²»ÈçÖ±½ÓÓóÌÐò¹ýÂË

---

ÄÇ»¹²»µÃreplace¶àÉٴΰ¡

---

¸Ð¾õÄѶȱȽϴ󣬽¨ÒéÔÚ³ÌÐòÖÐÓÃÕýÔòÀ´´¦Àí¡£

---

¸Ð¾õ»¹ÊÇÓÃÕýÔò±È½ÏºÃ

---

Èç¹ûÊÇÕâÑùÄã¿É°ÑËùÓкº×ÖÁôÏÂ

---

ÕýÔò±í´ïʽ.......

---

¿ÉÒÔÕâÑù
SQL code:

DECLARE @idoc int
DECLARE @doc nvarchar(1000)
SET @doc ='
<ul><li><a href=''/20_00_1.html''>ʯÅÆÇÅ</a></li><li><a href=''/20_0-1.html''>¹ãÖÝÌìºÓ¹«½»³¡</a></li><li><a href=''/20_0_4_0152_1.html''>ÌìºÓÄÏ</a></li></ul>
'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
-- Execute a SELECT statement that uses the OPENXML rowset provider.
SELECT *
from OPENXML (@idoc, '/ul/li',2)
WITH (a varchar(10))


/*
a
----------
ʯÅÆÇÅ
¹ãÖÝÌìºÓ¹«
ÌìºÓÄÏ

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©
*/

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://ww