我想把一个联合查询输出为一个xml的文件。已有基本的代码，但是复杂化就出错。谁帮我改一下。高分

Question

EXEC master..xp_cmdshell 'bcp "select distinct MOBILE_PICTYPE.MOBILE_PICTYPE_NO,
       leaf.BRAND,
       MOBILE_PICTYPE.MOBILE_TYPE_NO mobile_type_no0,
       MOBILE_PICTYPE.MOBILE_PICTYPE_NAME,
       MOBILE_PICTYPE.PIC_WIDTH,
       MOBILE_PICTYPE.PIC_HEIGHT,
       MOBILE_PICTYPE.IMAGE_FORMAT,
       MOBILE_PICTYPE.SCREEN_X,MOBILE_PICTYPE.SCREEN_Y,
       MOBILE_PICTYPE.COLOR_BIT,
       MOBILE_PICTYPE.MAX_DES_LEN,
       MOBILE_PICTYPE.MAX_PIC_LEN,
       MOBILE_PICTYPE.PIC_PROGID,
       MOBILE_PICTYPE.PROTOCOL_NAME,
       MOBILE_PICTYPE.STATIC_SERVICE_ID,
       MOBILE_PICTYPE.ANI_SERVICE_ID,
       MOBILE_PICTYPE.SUB_SERVICE_ID,
       MOBILE_PICTYPE.MONTH_SERVICE_ID,
       leaf.MOBILE_TYPE_NO,leaf.MODEL
from xcdb.dbo.mobile_pictype, 
(select distinct MOBILE_TYPE_NO,BRAND,MODEL from xcdb.dbo.MOBILE) leaf,
       MOBILE_PICTYPE
where leaf.MOBILE_TYPE_NO=MOBILE_PICTYPE.MOBILE_TYPE_NO for xml auto" 
queryout E:\DT.xml -c'

Answer 1

EXEC master..xp_cmdshell 'bcp "select distinct MOBILE_PICTYPE.MOBILE_PICTYPE_NO,
       leaf.BRAND,
       MOBILE_PICTYPE.MOBILE_TYPE_NO mobile_type_no0,
       MOBILE_PICTYPE.MOBILE_PICTYPE_NAME,
       MOBILE_PICTYPE.PIC_WIDTH,
       MOBILE_PICTYPE.PIC_HEIGHT,
       MOBILE_PICTYPE.IMAGE_FORMAT,
       MOBILE_PICTYPE.SCREEN_X,MOBILE_PICTYPE.SCREEN_Y,
       MOBILE_PICTYPE.COLOR_BIT,
       MOBILE_PICTYPE.MAX_DES_LEN,
       MOBILE_PICTYPE.MAX_PIC_LEN,
       MOBILE_PICTYPE.PIC_PROGID,
       MOBILE_PICTYPE.PROTOCOL_NAME,
       MOBILE_PICTYPE.STATIC_SERVICE_ID,
       MOBILE_PICTYPE.ANI_SERVICE_ID,
       MOBILE_PICTYPE.SUB_SERVICE_ID,
       MOBILE_PICTYPE.MONTH_SERVICE_ID,
       leaf.MOBILE_TYPE_NO,leaf.MODEL
from xcdb.dbo.mobile_pictype,(select distinct MOBILE_TYPE_NO,BRAND,MODEL from xcdb.dbo.MOBILE) leaf,
       MOBILE_PICTYPE
where leaf.MOBILE_TYPE_NO=MOBILE_PICTYPE.MOBILE_TYPE_NO for xml auto" queryout E:\DT.xml -c -Usa -Ppassword -Sservername'

Answer 2

建立例子模版：在C:\下新建内容为下面的一“模版.htp”
    <%insert_data_here%>再：
  exec sp_makewebtask 'c:\模版实例.txt','select distinct MOBILE_PICTYPE.MOBILE_PICTYPE_NO,
       leaf.BRAND,
       MOBILE_PICTYPE.MOBILE_TYPE_NO mobile_type_no0,
       MOBILE_PICTYPE.MOBILE_PICTYPE_NAME,
       MOBILE_PICTYPE.PIC_WIDTH,
       MOBILE_PICTYPE.PIC_HEIGHT,
       MOBILE_PICTYPE.IMAGE_FORMAT,
       MOBILE_PICTYPE.SCREEN_X,MOBILE_PICTYPE.SCREEN_Y,
       MOBILE_PICTYPE.COLOR_BIT,
       MOBILE_PICTYPE.MAX_DES_LEN,
       MOBILE_PICTYPE.MAX_PIC_LEN,
       MOBILE_PICTYPE.PIC_PROGID,
       MOBILE_PICTYPE.PROTOCOL_NAME,
       MOBILE_PICTYPE.STATIC_SERVICE_ID,
       MOBILE_PICTYPE.ANI_SERVICE_ID,
       MOBILE_PICTYPE.SUB_SERVICE_ID,
       MOBILE_PICTYPE.MONTH_SERVICE_ID,
       leaf.MOBILE_TYPE_NO,leaf.MODEL
from xcdb.dbo.mobile_pictype (select distinct MOBILE_TYPE_NO,BRAND,MODEL from xcdb.dbo.MOBILE) leaf,
       MOBILE_PICTYPE
where leaf.MOBILE_TYPE_NO=MOBILE_PICTYPE.MOBILE_TYPE_NO for xml auto',@templatefile='c:\模版.htp',@lastupdated=0,@resultstitle='  ',@charset='gb2312'