??????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????????