SQL Server SQL for xml auto Ìí¼Ó¸ù½Úµã

½ñÌì´ÓÊý¾Ý¿âÖвéѯ³öxml£¬Í¬Ê±Ìí¼ÓÒ»¸ö¸ù½Úµã
×öÁËÈçϲâÊÔ£º
create table TestXmlQuery(
ID int identity(1,1) not null,
Name varchar(10)
)
go
insert into [TestXmlQuery] (Name) values('²âÊÔ1')
insert into [TestXmlQuery] (Name) values('²âÊÔ2')
insert into [TestXmlQuery] (Name) values('²âÊÔ3')
insert into [TestXmlQuery] (Name) values('²âÊÔ4')
select t.ID as myID,t.Name as myName from [TestXmlQuery] as t for xml auto,type
µÃµ½ÈçϽá¹û£º
<t myID="1" myName="²âÊÔ1" />
<t myID="2" myName="²âÊÔ2" />
<t myID="3" myName="²âÊÔ3" />
<t myID="4" myName="²âÊÔ4" />
select t.ID as myID,t.Name as myName from [TestXmlQuery] as t for xml auto,elements
µÃµ½ÈçϽá¹û£º
<t>
<myID>1</myID>
<myName>²âÊÔ1</myName>
</t>
<t>
<myID>2</myID>
<myName>²âÊÔ2</myName>
</t>
<t>
<myID>3</myID>
<myName>²âÊÔ3</myName>
</t>
<t>
<myID>4</myID>
<myName>²âÊÔ4</myName>
</t>
select t.ID as myID,t.Name as myName from [TestXmlQuery] as t for xml raw
µÃµ½ÈçϽá¹û£º
<row myID="1" myName="²âÊÔ1" />
<row myID="2" myName="²âÊÔ2" />
<row myID="3" myName="²âÊÔ3" />
<row myID="4" myName="²âÊÔ4" />
select t.ID as myID,t.Name as myName from [TestXmlQuery] as t for xml raw,elements
µÃµ½ÈçϽá¹û£º
<row>
<myID>1</myID>
<myName>²âÊÔ1</myName>
</row>
<row>
<myID>2</myID>
<myName>²âÊÔ2</myName>
</row>
<row>
<myID>3</myID>
<myName>²âÊÔ3</myName>
</row>
<row>
<myID>4</myID>
<myName>²âÊÔ4</myName>
</row>
select t.ID as myID,t.Name as myName from [TestXmlQuery] as t for xml raw,elements,