22,210
社区成员
发帖
与我相关
我的任务
分享
--emp.tmp
<Employees>
<%begindetail%>
<Employee Badge="<%insert_data_here%>">
<Name><%insert_data_here%></Name>
<Department DepID="<%insert_data_here%>">
<DepCName><%insert_data_here%></DepCName>
</Department>
<Job JobID="<%insert_data_here%>">
<JobCName><%insert_data_here%></JobCName>
</Job>
<Status><%insert_data_here%></Status>
<StartDate><%insert_data_here%></StartDate>
<LeaDate><%insert_data_here%></LeaDate>
</Employee>
<%enddetail%>
</Employees>
--emp.tmp模板文件
<?xml version="1.0" encoding="utf-8"?>
<Employees>
<%begindetail%>
<Employee Badge="<%insert_data_here%>" Name="<%insert_data_here%>" DepID="<%insert_data_here%>" DepCName="<%insert_data_here%>" JobID="<%insert_data_here%>" JobCName="<%insert_data_here%>" Status="<%insert_data_here%>" StartDate="<%insert_data_here%>" LeaDate="<%insert_data_here%>" />
<%enddetail%>
</Employees>
exec sp_makewebtask @outputfile = 'D:\emp.xml',
@query = 'SELECT top 10 Badge,Name,a.DepID,b.DepCName,a.JobID,c.JobCName,Status,
convert(varchar(10),startdate,120) StartDate,
isnull(convert(varchar(10),LeaDate,120),'''') LeaDate,
a.Remark
FROM employee a,department b,job c
where a.depid=b.depid and a.jobid=c.jobid',
@templatefile = 'D:\emp.tmp',
@dbname = 'demo'
--这样就可以了
exec master..xp_cmdshell
'bcp TestDB.dbo.TB format nul -c -x -f Department-c..xml -T'