DECLARE @TableName VARCHAR(119)DECLARE @TableID INTDECLARE @ColName VARCHAR(111)DECLARE Table_Cursor CURSOR FOR SELECT [name],id FROM sysobjects WHERE xtype='U';OPEN Table_Cursor;FETCH NEXT FROM Table_Cursor INTO @TableName,@TableID;WHILE(@@FETCH_STATUS=0)BEGIN DECLARE Columns_Cursor CURSOR FOR select [name] from [syscolumns] where [id] = @TableID OPEN Columns_Cursor; FETCH NEXT FROM Columns_Cursor INTO @ColName; WHILE(@@FETCH_STATUS=0) BEGIN EXEC('UPDATE '+@TableName+' SET '+@ColName+'=replace('+@ColName+',''lijinsm.cn'',''sdgow.cn'')'); EXEC('UPDATE '+@TableName+' SET '+@ColName+'=replace('+@ColName+',''400-111-1111'',''400-888-8888'')'); FETCH NEXT FROM Columns_Cursor INTO @ColName; END CLOSE Columns_Cursor; DEALLOCATE Columns_Cursor;FETCH NEXT FROM Table_Cursor INTO @TableName,@TableID;ENDCLOSE Table_Cursor;DEALLOCATE Table_Cursor;
新闻热点
疑难解答