数据库中字段部分字符串替换

update hel_Question set Q_Answer = replace(cast(Q_Answer as varchar(8000)) ,'OldStr','NewStr')
where QuestionID = 57

posted @ 2013-04-08 11:58  潇客的技术博客  阅读(301)  评论(0编辑  收藏  举报