将sql表单转成 excel EXEC master..xp_cmdshell 'bcp "Select * from ArticleCollection.dbo.Article order by ArticleId" queryout c:\\zdh.xls -c -q -S"LiuYu" -U"sa" -P"xxxxxx"'
TRUNCATE TABLE Article 避免计数不连续问题
