XML Query

declare @str xml
set @str =' <root>
<row servername="CIPUSQLL26\SQL2005" dbname="Lab_SQL_Server_Inventory" cnt="8"/>
<row servername="CIPUSQLL26\SQL2005" dbname="Distribution" cnt="2"/>
<row servername="CIPUSQLL26\SQL2005" dbname="ReportServer2" cnt="3"/>
</root>'
select @str;

ÎÒÏëµÃµ½ÈçϽá¹û²¢ÐèÒª²åÈëµ½Ò»¸ö±íÖÐ(²»ÄÜÒÔXMLÐÎʽ·µ»Ø).лл£¡

servarname              dbname                        cnt
CIPUSQLL26\SQL2005      Lab_SQL_Server_Inventory        8
CIPUSQLL26\SQL2005      Distribution                    2
CIPUSQLL26\SQL2005      ReportServer2                  3

---

¿ÉÒÔÔÚǰ̨³ÌÐò,Ö±½ÓÀûÓÃDATASET.READXML·½·¨¶Á³öÀ´

---

SQLServer2005 XMLÔÚT£­SQL²éѯÖеĵäÐÍÓ¦ÓÃ
http://topic.csdn.net/u/20081107/17/68aaf5a9-c596-4ab5-ae18-f3370b2ab35b.html

---

ÒýÓÃ

SQL codedeclare@str xmlset@str=' <root>
<row servername="CIPUSQLL26\SQL2005" dbname="Lab_SQL_Server_Inventory" cnt="8"/>
<row servername