替换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
发布时间: 2012-08-31 12:55:03 作者: rapoo
替换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