疯狂二十九笔

摘要： 作用：把某字段中的某个值全部替换为另一个值declare @id intdeclare cursorID cursor for select id from T_Video where url like '%http://iilloo.com.cn%'open cursorIDfetch next from cursorID into @idwhile @@fetch_status=0begin declare @url varchar(500) select @url= url from T_Video where id=@id set @url=replace(@url,& 阅读全文