谁帮我看看这个百分号是什么意思,刚学,请教
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数据库吗???