34,588
社区成员
发帖
与我相关
我的任务
分享
update rpcustomer
set other_col='col值'
where right('coustomer_code',4)='1001'
UPDATE a
SET a.xxx=a.yyyy
FROM rpcustomer a
WHERE RIGHT(b.coustomer_code,4)='1001'
UPDATE a
SET a.xxx=a.yyyy
FROM rpcustomer a
WHERE EXISTS(
SELECT 1 FROM rpcustomer b WHERE RIGHT(b.coustomer_code,4)='1001' AND a.customer_id=b.customer_id)
select right('A0011001',4)