create xml file from sql script
2024-10-23 01:58:43
Declare @xmlDoc xml
SET @xmlDoc = (SELECT * FROM USERS AS UserTable For XML AUTO, ELEMENTS, ROOT('Root'))
SELECT @xmlDoc
Result as below :
<Root>
<UserTable>
<UserDBID>1</UserDBID>
<UserID>Admin </UserID>
<UserName>admin</UserName>
<Password>49CE5FB6D05148ACB66A</Password>
<FullName />
<LocalFullName />
<Title />
<Department />
<UserRole>Administrator</UserRole>
<IsFirstLogin>0</IsFirstLogin>
<PwdNeverExpire>1</PwdNeverExpire>
<PwdLastModifyTime>2013-07-10T13:40:48.470</PwdLastModifyTime>
</UserTable>
<UserTable>
<UserDBID>2</UserDBID>
<UserID>cshsvc </UserID>
<UserName>cshsvc</UserName>
<Password>54C0FCD2B54CCE8BE6AD</Password>
<FullName />
<LocalFullName />
<Title />
<Department />
<UserRole>Administrator</UserRole>
<IsFirstLogin>0</IsFirstLogin>
<PwdNeverExpire>1</PwdNeverExpire>
<PwdLastModifyTime>2013-07-10T13:38:25.070</PwdLastModifyTime>
</UserTable>
</Root>
SelectEmp_Id,Emp_Namefrom tblEmployee WhereEmp_Id<3For XML AUTO,ELEMENTS
--For XML [MODE],ELEMENTSMODE
AUTO, RAW, EXPLICIT
Result [AUTO]
<tblEmployee><Emp_Id>1</Emp_Id><Emp_Name>AAA</Emp_Name></tblEmployee><tblEmployee><Emp_Id>2</Emp_Id><Emp_Name>BBB</Emp_Name></tblEmployee>Result [RAW]
Above Xml with Instead of <tblEmployee> here..... <ROW> and </tblEmployee> is </ROW>
SELECT ( SELECT 'White' AS Color1,
'Blue' AS Color2,
'Black' AS Color3,
'Light' AS 'Color4/@Special',
'Green' AS Color4,
'Red' AS Color5
FOR
XML PATH('Colors'),
TYPE
),
( SELECT 'Apple' AS Fruits1,
'Pineapple' AS Fruits2,
'Grapes' AS Fruits3,
'Melon' AS Fruits4
FOR
XML PATH('Fruits'),
TYPE
)
FOR XML PATH(''),
ROOT('SampleXML')
GO
最新文章
- JavaScript基础知识总结（一）
- 升级xcode7的问题：使用shareSDK，坑的你两眼泪汪汪
- js兼容
- 纯JavaScrip图表插件——Highcharts
- WebService中实现上传下载文件
- jvm常量池 vsv为什么1000 == 1000返回为False，而100 == 100会返回为True?
- js 效果样式大全
- linux 高精度定时器例子
- scrapy中的request
- 关于softmax、argmax、softargmax
- OpenSSL-Win64创建IdentityServer证书
- Spark进阶之路-Standalone模式搭建
- 【Ruby】【改gem源镜像】【Win10 + Jruby-9.1.2.0 + Rails 5.1.3 + gem 2.6.4 】
- 【BZOJ-2329&2209】括号修复&括号序列 Splay
- spring-cloud: eureka之：ribbon负载均衡配置（一）
- MyEclipse移动开发教程：迁移HTML5移动项目到PhoneGap（二）
- Java5的新特性
- 在 Linux 上使用 Nginx 和 Gunicorn 托管 Django 应用
- SiteMesh使用(2.4.2)
- linux安装配置apache服务（httpd）