update Table
set content= replace(content,'222','')
ERROR
Argument data type text is invalid for argument 1 of replace function
更改为
update Table
set content=replace(cast(content as varchar(8000)),'22','')
update Table
set content= replace(content,'222','')
ERROR
Argument data type text is invalid for argument 1 of replace function
更改为
update Table
set content=replace(cast(content as varchar(8000)),'22','')