sqlserver for xml
                        
                            时间:2021-07-01 10:21:17
                            帮助过:25人阅读
							                        
                     
                    
                    
                     * from baseType_bty 
for xml auto
select * from baseType_bty 
for xml 
raw
select * from baseType_bty 
for xml 
raw, elements
select * from baseType_bty 
for xml 
raw, elements xsinil
SELECT * FROM baseType_bty 
FOR XML PATH
--自定义的名称<MyHobby>,
SELECT * FROM baseType_bty 
FOR XML PATH(
‘MyHobby‘)
 
sqlserver for xml
标签:nbsp   nil   select   style   函数   explicit   type   span   xpath