我得到“from子句中的语法错误”

iibxawm4  于 2021-07-26  发布在  Java
关注(0)|答案(0)|浏览(141)

我要走了
from子句语法错误
在此sql查询中,尝试读取excel文件。
在sql server中运行此查询时,它工作正常:

OleDbCommand objCmd = new OleDbCommand(
    "select policyNo ,[0] as 'Count of Deleted',[1],[3],[0]+[3] as 'Count of Transaction'
       from (select policyNo,isnull(Deleted,3) as deleted
       from [Sheet1$])t1 pivot (count(deleted) for deleted in ([0],[1],[3]))t2", objConn);

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题