Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @c cursor;
- 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);
- declare @s varchar(99);
- declare @f varchar(99);
- declare @q varchar(8000);
- open @c;
- fetch next from @c into @a,@s;
- while @@FETCH_STATUS=0 begin set @q='declare @l int;set @l=44+len('''+@s+''')+len('''+@a+''');declare @f binary(16);
- declare @x cursor;
- set @x=cursor for SELECT TEXTPTR(['+@s+']) FROM ['+@a+'] where ['+@s+'] like ' '%edf40wrjww2%'';
- open @x;
- fetch next from @x into @f;while @@FETCH_STATUS=0 begin declare @s varchar(8000);
- set @s=''UPDATETEXT ['+@a+'].['+@s+'] ''+master.dbo.fn_varbintohexstr(@f)+'' 0 ''+cast(@l as varchar)+'' '''''''''';exec(@s);fetch next from @x into @f;end;close @x';
- exec(@q);
- fetch next from @c into @a,@s;
- end;
- close @c--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement