两边加多一个单引号就行
exec master..xp_cmdshell 'bcp "select c1 FROM abc.dbo.vi_tablename where A like ''ABC%''" queryout c:\temp.xls -c -SDICKY -Usa -Pxxx'
exec master..xp_cmdshell 'bcp "select c1 FROM abc.dbo.vi_tablename where A like ''ABC%''" queryout c:\temp.xls -c -SDICKY -Usa -Pxxx'
经实践, 两边加多一个单引号是对的.