sql之Replace

update [ConfigDb].[dbo].[RuleParams] set RuleName=REPLACE(RuleName,'业务','') where (RuleId>358 or (RuleId<358 and RuleId>=332)) and RuleName like '%业务%' Replace(字段名,'要替换的内容','新内容')
posted @ 2016-07-06 13:30  闲得无聊敲代码  阅读(239)  评论(0)    收藏  举报