--遍历所有表
declare @tmpId int
declare @tmpfiles nvarchar(127)
declare tb_Tmp cursor for
select Id,files from peopletb
open tb_Tmp
fetch next from tb_Tmp into @TmpId,@tmpfiles
WHILE @@FETCH_STATUS = 0
BEGIN
print @tmpfiles
set @tmpfiles=REPLACE(@tmpfiles,'192.168.0.102','www.zh-rc.net')
print @tmpfiles
update peopletb set files=@tmpfiles where Id=@tmpId
fetch next from tb_Tmp into @TmpId,@tmpfiles
END
close tb_Tmp
DEALLOCATE tb_Tmp
--删除临时表
if object_id('tempdb.dbo.#tb')is not null
begin
drop table #tb
end
--建立临时表
CREATE TABLE #tb(
[Id] INT,
Prize decimal(32,2),
ProName Nvarchar(127)
)
if @@error<>0
begin
rollback tran
return -1
end