表结构如下: Categor(CategoryID,Name,Unit) 导出为XML文件到F:\Category.xml 语句为:exec master..xp_cmdshell 'bcp "select ''<Cagegory>'' union all select '' <Category CategoryID=''+char(34)+''''+cast(CategoryID as varchar)+''''+char(34)+'' Name=''+char(34)+''''+rtrim(Name)+''''+char(34)+'' Unit=''+char(34)+''''+cast(Unit as varchar)+''''+char(34)+'' />'' from Report.dbo.SecurityRectifyCategory union all select ''</Cagegory>''" queryout "F:\Category.xml" /U"sa" /P"" /c' go ---------------------------------------------------- 记得给分!
这里面的引号全是单引号: -----------------------------select ''<Cagegory>'' union all select '' <Category CategoryID=''+char(34)+''''+cast(CategoryID as varchar)+''''+char(34)+'' Name=''+char(34)+''''+rtrim(Name)+''''+char(34)+'' Unit=''+char(34)+''''+cast(Unit as varchar)+''''+char(34)+'' />'' from Report.dbo.SecurityRectifyCategory union all select ''</Cagegory>''
Categor(CategoryID,Name,Unit)
导出为XML文件到F:\Category.xml
语句为:exec master..xp_cmdshell
'bcp "select ''<Cagegory>'' union all
select '' <Category CategoryID=''+char(34)+''''+cast(CategoryID as varchar)+''''+char(34)+'' Name=''+char(34)+''''+rtrim(Name)+''''+char(34)+'' Unit=''+char(34)+''''+cast(Unit as varchar)+''''+char(34)+'' />''
from Report.dbo.SecurityRectifyCategory union all select ''</Cagegory>''" queryout "F:\Category.xml" /U"sa" /P"" /c'
go
----------------------------------------------------
记得给分!
---------------------------------------
<ReportCategory>
<Category CategoryID="Advertisement" Name="商标广告存在问题的企业" Unit="户" />
<Category CategoryID="Aquatic" Name="水产制品" Unit="公斤" />
<Category CategoryID="Bean" Name="豆制品" Unit="公斤" />
<Category CategoryID="Beverage" Name="饮料" Unit="瓶" />
<Category CategoryID="Child" Name="儿童食品" Unit="公斤" />
<Category CategoryID="Condiment" Name="调味品" Unit="公斤" />
<Category CategoryID="CounterfeitCase" Name="查处制售假冒伪劣食品案件数量" Unit="件" />
<Category CategoryID="CounterfeitFine" Name="查处制售假冒伪劣食品案件罚没金额" Unit="万元" />
<Category CategoryID="DestroyCounterfeit" Name="捣毁制假售假窝点" Unit="个" />
<Category CategoryID="DryMushroom" Name="干制菌苗" Unit="公斤" />
<Category CategoryID="EdibleOil" Name="食用油" Unit="公斤" />
<Category CategoryID="Examine" Name="进货检查验收存在问题的企业" Unit="户" />
<Category CategoryID="FoodStuff" Name="粮食制品" Unit="公斤" />
<Category CategoryID="Meat" Name="肉类制品" Unit="公斤" />
<Category CategoryID="Milk" Name="奶制品" Unit="公斤" />
<Category CategoryID="Nutrition" Name="营养保健食品" Unit="公斤" />
<Category CategoryID="Packing" Name="包装标识存在问题的企业" Unit="户" />
<Category CategoryID="Personnel" Name="出动执法人员" Unit="人/次" />
<Category CategoryID="Pickle" Name="腌熏制品" Unit="公斤" />
<Category CategoryID="Qualification" Name="经营资质存在问题的企业" Unit="户" />
<Category CategoryID="Quality" Name="食品质量存在问题的企业" Unit="户" />
<Category CategoryID="Rest" Name="其他" Unit="公斤" />
<Category CategoryID="RevokeLicense" Name="吊销营业执照" Unit="户" />
<Category CategoryID="Tin" Name="罐头" Unit="听" />
<Category CategoryID="ToPoliceCase" Name="移送公安机关案件数量" Unit="件" />
<Category CategoryID="TotalCheck" Name="检查经营户" Unit="户" />
<Category CategoryID="Unlicense" Name="查处无照经营户" Unit="户" />
<Category CategoryID="VegetableFruit" Name="蔬菜水果" Unit="公斤" />
<Category CategoryID="Wine" Name="酒" Unit="瓶" />
</Category>
-----------------------------select ''<Cagegory>'' union all
select '' <Category CategoryID=''+char(34)+''''+cast(CategoryID as varchar)+''''+char(34)+'' Name=''+char(34)+''''+rtrim(Name)+''''+char(34)+'' Unit=''+char(34)+''''+cast(Unit as varchar)+''''+char(34)+'' />''
from Report.dbo.SecurityRectifyCategory union all select ''</Cagegory>''