Question

关键字 'where' 附近有语法错误

merge into FACTORY_STATISTICS fs using (select count(*) as count from FACTORY_STATISTICS where FACTORYCODE = '1000' and MATERIALID ='cd98f717-148d-4200-9dbc-0bca1916118e') condition on (condition.count > 0) when matched then update set fs.PARTAVANUM = fs.PARTAVANUM + '24.000', fs.MATCHAVANUM = fs.MATCHAVANUM + '0', fs.AVAILABLENUM = fs.AVAILABLENUM + '24.000', fs.TOTALNUM = fs.TOTALNUM + '24.000' where fs.FACTORYCODE = '1000' and fs.MATERIALID = 'cd98f717-148d-4200-9dbc-0bca1916118e' WHEN NOT MATCHED THEN INSERT (fs.ID,fs.FACTORYCODE,fs.MATERIALID,fs.PARTAVANUM,fs.PARTFREEZENUM,fs.PARTLOCKNUM,fs.MATCHAVANUM,fs.MATCHFREEZENUM,fs.MATCHLOCKNUM,fs.AVAILABLENUM,fs.FREEZENUM,fs.LOCKNUM,fs.TotalNum) values ('9feae664-a8db-4cd8-806e-ad92d55551e4','1000','cd98f717-148d-4200-9dbc-0bca1916118e','24.000','0','0','0','0','0','24.000','0','0','24.00.')错误日志SqlExceptionHelper - SQL Error: 156, SQLState: S0001
SqlExceptionHelper - 。
错误原因是orcale数据库转到sqlsever后发生

Answer 1

update dbo.Wen_elm set elm='"&request("elm"&i)&"',epx="&request("epx"&i)&" where eid="&request("eid"&i) 后面不用加&这个 这个好像叫连接符 只有在后面还有字符串的时候才用的 。

追问

完全跟我的问题不一致