SQLserver2008批量替换字符串

来源:这里教程网 时间:2026-03-02 11:44:49 作者:

--替换字符串 UPDATE b_Inventory SET cInvCode= replace(cInvCode,'020103','04010104')  FROM   b_InventoryClass s2 LEFT JOIN b_Inventory s1 ON  s1.InventoryCalssID=s2.ID WHERE s2.cInvCCode='04010104'

相关推荐