SQL server2008中执行SQL脚本导入数据和导出数据成XML格式

        执行SQL脚本导入数据：sqlcmd -S SERVERNAME -U USERNAME -P PASSWORD -i filename.sql

        导出到xml文件：bcp master.dbo.Tweet out d:\Tweet.xml -w -U"sa" -P"*****" -S"*****"

        导出到XML文件应该是这样的：exec master..xp_cmdshell 'bcp "SELECT ''<?xml version=""1.0"" encoding=""gb2312"" ?>'' + (SELECT  TOP 20 id AS''@id'' ,content,title FROM zhongyi.dbo.News FOR XML path(''news''),root(''world''))" queryout "d:\a2.xml" -c -S"***" -U"sa" -P"***" -t'

        FOR XML：select TOP 20 id AS "@id" ,content,title from zhongyi.dbo.News for XML PATH('news')

 

       BCP+SQL组合命令还是蛮强大的，得好好研究啊，再续