update originalsalesdata a
set customerid=dtid,customerclear= 'N '
where a.salesdatafileid=%salesdatafileid
------解决方案--------------------
我怎么这样写报错阿
应该为这样吧:
update originalsalesdata a
set customerid=dtid,customerclear= 'N '
where a.salesdatafileid like %salesdatafileid
%salesdatafileid 相当于 后缀为salesdatafileid 的字符串
------解决方案--------------------
update originalsalesdata a
set customerid=dtid,customerclear= 'N '
where a.salesdatafileid like '%salesdatafileid '
是什么类型?
------解决方案--------------------
你是ORACLE数据库吗???