将‘0654879’替换成‘0754879’
UPDATE dbo.SG_Functionality SET FunctionalityCode=REPLACE(FunctionalityCode,'06','07') WHERE Type=2 AND FunctionalityCode LIKE '06%'
本文共 208 字,大约阅读时间需要 1 分钟。
将‘0654879’替换成‘0754879’
UPDATE dbo.SG_Functionality SET FunctionalityCode=REPLACE(FunctionalityCode,'06','07') WHERE Type=2 AND FunctionalityCode LIKE '06%'
转载于:https://www.cnblogs.com/heyiping/p/11382365.html