Sql Server关于text类型的替换

UPDATE Store SET Body=replace(convert(varchar(8000),Body),'http://120.89.46.68:8007','')

posted @ 2013-08-09 14:54 ypa 阅读(297) 评论(0) 收藏举报