Question

大侠们！来看看我 将查询的结果生成XLS文件 出错了 那位看看 谢谢了

exec master..xp_cmdshell 'bcp "sselect top 10 Nick,Money,Win,Lose from tbhgamedata.dbo.[30miao] order by Money desc" queryout "E:\TBcx.xls" -c -S (local) -U DBAdmin -P 123456’

报错是：

SQLState = 37000, NativeError = 156
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]关键字 'top' 附近有语法错误。
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]无法预定义语句。
NULL

Answer 1

exec master..xp_cmdshell 'bcp " select top 10 Nick,Money,Win,Lose from tbhgamedata.dbo.[30miao] order by Money desc" queryout "E:\TBcx.xls" -c -S (local) -U DBAdmin -P 123456’

select 多写了个s
不知道'bcp 是什么意思？是不是缺少个'?