我怎么这样写报错阿 应该为这样吧: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'是什么类型?
应该为这样吧:update originalsalesdata a
set customerid=dtid,customerclear='N'
where a.salesdatafileid like %salesdatafileid%salesdatafileid 相当于 后缀为salesdatafileid 的字符串
set customerid=dtid,customerclear='N'
where a.salesdatafileid like '%salesdatafileid'是什么类型?