1.更新表里的某一列中的數(shù)據(jù)里帶有dev的數(shù)據(jù)，將dev替換成devcr。
select * from [Firefly].[System_Menu_Action]
where LinkUrl like '%/dev/%'
update[Firefly].[System_Menu_Action] set LinkUrl =
replace(LinkUrl , '/dev/','/devcr/') where LinkUrl like '%/dev/%'
