替换sql server 中的text类型中内容的关键词留个笔记update test set test.content test1.b from test, (
替换sql server 中的text类型中内容的关键词 留个笔记
update test set test.content =test1.b from test, (select id as a,REPLACE(CAST( content as varchar),'日本','日本鬼子')as b from test) test1where test.id =test1.a
