??????sql????ù?????У???????????????????????????????????????洢????????????????????Info??????????????Educational?????????????洢????Json???飬???????????????????????????洢??????Json??????????????????????????滻?????????????????????????????????????????????????sql???е?REPLACE?????????????????????????
????REPLACE
????????????????滻???????????????г???????е???????????????????
??????
????REPLACE ( ''string_replace1'' ?? ''string_replace2'' ?? ''string_replace3'' )
????????
????''string_replace1''
???????????????????????string_replace1 ????????????????????????
????''string_replace2''
??????????????????????string_replace2 ????????????????????????
????''string_replace3''
?????滻??????????????string_replace3 ????????????????????????
????????????
??????? string_replace??1??2 ?? 3???????????????????????????????????
??????? string_replace??1??2 ?? 3???????? binary ??????????????????????????
???????
?????????? xxx ?滻 abcdefghi ?е?????? cde??
????SELECT REPLACE(''abcdefghicde''??''cde''??''xxx'')GO
????????????????
????------------abxxxfghixxx(1 row(s) affected)
???????????????????????????
???????????????????????д洢??????????????????????? Update????Σ???????????????????????滻???????????? REPLACE??
?????ó???sql??????￡?
????update [Info] set [Educational] =(select REPLACE(REPLACE([Educational]??'['??'')??']'??''))
????????????Sql????????д洢???????????Json??????Json????????