34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[TXmlData](
[FID] [int] IDENTITY(1,1) NOT NULL,
[XmlNode] [xml] NOT NULL,
CONSTRAINT [PK_TXmlData] PRIMARY KEY CLUSTERED
(
[FID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
insert into TXmlData values('<PicUrl><![CDATA[ae3ceb5c-fee9-459a-a3ef-dce238360d27]]></PicUrl>')
<PicUrl>ae3ceb5c-fee9-459a-a3ef-dce238360d27</PicUrl>
<PicUrl><![CDATA[ae3ceb5c-fee9-459a-a3ef-dce238360d27]]></PicUrl>
<PicUrl><![CDATA[ae3ceb5c-fee9-459a-a3ef-dce238360d27]></PicUrl>
SELECT v FROM TXmlData t1
cross apply (select n.v.value('.','varchar(100)')v from t1.XmlNode.nodes('/PicUrl') n(v))t2
--<![CDATA[ae3ceb5c-fee9-459a-a3ef-dce238360d27]>