declare @str vArchar(100)
set @str='8f8el3l'

declare @s VARchar(8000)
declare tb cursor local for
select s='if exists(select 1 From ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
PRint ''所在的表及字段: ['+b.name+'].['+a.name+']'''
from Syscolumns a join sysobjects b on a.id=b.id
where b.xtyPE='U' and a.status>=0
and a.xusertype in(175,239,231,167)
open tb
fetch next from tb into @s
while @@fetch_status=0
begin
exec(@s)
fetch next from tb into @s
end
close tb
deallocate tb