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
?
