替换文中指定字段实例

select * from dbo.QD_News where Contents like '%FONT-FAMILY: 仿宋_GB2312;%'
update dbo.QD_News set Contents=replace(covert(ntext,Contents),'FONT-FAMILY: 仿宋_GB2312;'，'FONT-FAMILY: 宋体;')
update dbo.QD_News set Contents=replace(convert(varchar(8000),Contents),'FONT-FAMILY: 仿宋_GB2312;','FONT-FAMILY: 宋体;')

posted @ 2012-09-13 15:59  Xyang  阅读(127)  评论(0)  编辑  收藏  举报
hi