我要走了
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);
暂无答案!
目前还没有任何答案,快来回答吧!