遍历数据库，所有表中所有字段，将指定字符串（部分大小写）修改为自定字符串 MSSQLServer2005

Create PROC [dbo].[GetAllThing](@oldString NVARCHAR(100),@newString NVARCHAR(100))ASBEGIN DECLARE @tablename VARCHAR(100)DECLARE @columnname VARCHAR(100)DECLARE @columnCount INTDECLARE @tmpTable VARCHAR(100)SET @tmpTable = ''--查询的到库中的所有用户表--SELECT name FROM sysobjects WHERE xtype='U'BEGIN TRANDECLARE tmpTableName CURSOR FOR SELECT name FROM sysobjects WHERE xtype='U'OPEN tmpTableNameFETCH NEXT FROM tmpTableName INTO @tablenameWHILE @@FETCH_STATUS=0BEGINSET @columnname=''--查询的到TemplateInfo表中的所有字段--SELECT NAME FROM syscolumns s WHERE OBJECT_NAME(id)='TemplateInfo'BEGIN TRan DECLARE tmpColumnName CURSOR FORSELECT NAME FROM syscolumns s WHERE OBJECT_NAME(ID)=@tablenameselect @columnCount= COUNT(NAME) FROM syscolumns WHERE OBJECT_NAME(id)=@tablenameOPEN tmpColumnNameFETCH NEXT FROM tmpColumnName INTO @columnnameWHILE @@FETCH_STATUS=0BEGINset @tmpTable ='UPDATE '+ @tablename +'set '+@columnname + ' = '+@newString +' WHERE '+@columnname+' LIKE ''%' +LOWER(@oldString)+'%'EXEC (@tmpTable)FETCH NEXT FROM tmpColumnName INTO @columnnameEND COMMIT TRAN CLOSE tmpColumnName DEALLOCATE temColumnName FETCH NEXT FROM tmpTableName INTO @tablenameEND COMMIT TRANCLOSE tmpTableNameDEALLOCATE tmpTableNameEND