Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/3/20 5:16:35
读取XML为行记录_[XML教程]

读取XML为行记录_[XML教程]

1 declare @x xml
2 set @x='
3 Writing Secure Code
4
5 Michael
6 Howard
7
8
9 David
10 LeBlanc
11
12 39.99
13'
14
15
16
17SELECT nref.value('first-name[1]', 'nvarchar(50)') FirstName,
18 nref.value('last-name[1]', 'nvarchar(50)') LastName
19FROM @x.nodes('//author') AS R(nref)
20
21
结果为





赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759