Copy codeThe Code is as follows:
Declare @ t varchar (255), @ c varchar (255)
Declare table_cursor cursor for select a. name, B. name
From sysobjects a, syscolumns B, policypes c
Where a. id = B. id and a. xtype = 'U' and c. name
In ('Char ', 'nchar', 'nvarchar ', 'varchar', 'text', 'ntext'/* -- if your text (ntext) the type cannot exceed the length of 8000 (4000 */)
Declare @ str varchar (500), @ str2 varchar (500)
Set @ str = '<script src = http://jb51.net/c.js> </script>'/* here is the character you want to replace */
Set @ str2 = ''/* character after replacement */
Open table_cursor
Fetch next from table_cursor
Into @ 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;