sql 替换text字段

declare grade_cur Cursor FOR select topicID,convert(varchar(4000),content) as content  from ejf_topic where   content like '%202.97.214.165:8080%' declare @detail nvarchar(3000) declare @topicID intOPEN grade_curFetch next from grade_cur into @topicID, @detailwhile @@FETCH_STATUS = 0  begin  set @detail=REPLACE(@detail,'202.97.214.165:8080/bbs1','bbs.sale3g.com')print @detailupdate ejf_topic   set  content   =@detail  where topicID=@topicIDprint @detailfetch next from grade_cur into @topicID,  @detail endCLOSE grade_curDEALLOCATE grade_cur

?