刚刚一直有问题，无法显示，现在完整发一遍，麻烦点击一下采纳，谢谢

--把数据库名字 demoysc32 换成你自己的数据库名字就可以了
use demoysc32 
declare @myxml xml
set @myxml='<Peoples>
                <people>
                    <Name>dongsheng</Name>
                    <Sex>男</Sex>
                    <QQ>423545</QQ>
                </people>
                <people>
                    <Name>土豆</Name>
                    <Sex>男</Sex>
                    <QQ>123123</QQ>
                </people>
                <people>
                    <Name>choushuigou</Name>
                    <Sex>女</Sex>
                    <QQ>54543545</QQ>
                </people>
            </Peoples>'

--获得所有student节点的数据,每一行显示一条people节点的数据      
/*select @myxml.query('.')  as result from @myxml.nodes('/Peoples/people') as  T(c) */
--将这些数据显示为一个表格
select  T.c.value('(./Name)[1]','nvarchar(16)') as name,
        T.c.value('(./Sex)[1]','nvarchar(4)') as sex,
        T.c.value('(./QQ)[1]','nvarchar(16)') as QQ
        from @myxml.nodes('/Peoples/people') as T(c)

执行结果，就是你想要的

泡le沫

sql server 字符转换问题，急急急

11条回答

为你推荐