想要把資料庫關於 '123'的字串 取代成 '456'時 該怎麼下update
或是想要一口氣insert一個集合時
update
update SCFUNM set FUN_NAME = b.FUN_NAME
FROM (SELECT FUN_ID, REPLACE(FUN_NAME,'選項','計畫') as FUN_NAME
FROM SCFUNM
WHERE FUN_NAME LIKE '%選項%') b
WHERE SCFUNM.FUN_ID = B.FUN_ID