留个笔记
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
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