在sql server中能執行的語句在delphi中不能執行
WITH AAA AS (
SELECT SUBSTRING(F41,1,4) AS YEA_ID,SUBSTRING(F41,6,2) AS MON_ID
,ISNULL(COUNT(PROJ_ID),0) AS PROJ_COUNT
,ISNULL(SUM(ISNULL(F13,0)),0) AS PROJ_PRICE
FROM BMS_V_JSW_FE_BASIC_DATA
WHERE F41 <> ''
GROUP BY SUBSTRING(F41,1,4),SUBSTRING(F41,6,2)
)
SELECT * FROM AAA
這句話在DELPHI中不能執行,錯誤信息:"INCORRECT SYNTAX NEAR THE KEYWORD 'WITH'"
[解决办法]
with前加分号
