时间戳

首页 > 解决方案 > 我收到“FROM 子句中的语法错误”

sql - 我收到“FROM 子句中的语法错误”

问题描述

我正进入（状态

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);

标签： sqlc#-4.0

解决方案

推荐阅读