Replace some content of all fields in all tables in the SQLServer database with the table field content declare @ tvarchar (255), @ cvarchar (255) values, B. namefromsysobjectsa, syscolumnsb, policypescwherea. uandc
Replace some content of all fields in all tables in the SQL Server database with declare @ t varchar (255), @ c varchar (255) declare table_cursor cursor for select. name, B. name from sysobjects a, syscolumns B, policypes c where. id = B. id and. xtype = 'U' and c
Replace some content of all fields in all tables in the SQL Server database with the table field content
Declare @ t varchar (255), @ c varchar (255) declare table_cursor cursor for select. name, B. name from sysobjects a, syscolumns B, policypes c where. id = B. id and. xtype = 'U' and c. name in (-- here is the replacement type 'Char ', 'nchar', 'nvarchar ', 'varchar', 'text ', 'text' -- if your text (ntext) type does not exceed 8000 (4000) length, you can use) declare @ str varchar (500), @ str2 varchar (500) -- Here is the original character you want to replace: set @ str = 'A' -- here is the new character you want to replace: set @ str2 = 'bb' open table_cursor fetch next from table_cursor @ t, @ c while (@ fetch_status = 0) begin exec ('Update ['+ @ t +'] set ['+ @ c +'] = replace (cast (['+ @ c +'] as varchar (8000) ), ''' + @ str + ''', ''' + @ str2 + ''') ') fetch next from table_cursor into @ t, @ c end close table_cursor deallocate table_cursor;