遍历数据库查找某个字符串

 --从字段为'char','nchar','varchar','nvarchar','text','ntext'中筛选字符串"9999"：
create table #cc(ss int)
create table #bb(tablename varchar(100),colname varchar(100))
declare @count int,@tablename varchar(100),@colname varchar(100)
select id=identity(int,1,1),tablename=a.name,colname=b.name,c.name
into #aa
from sysobjects a join syscolumns b on a.id=b.id
join systypes c on b.xtype=c.xtype
where a.xtype='u' and c.name in('char','nchar','varchar','nvarchar')
set @count=@@rowcount
while @count>0
    begin
 select @tablename=tablename,@colname=colname from #aa where @count=id
 insert #cc(ss)
exec('select 1 from '+@tablename+' where '+@colname+' like '''+'%9999%''')
 if @@rowcount>0
     insert #bb(tablename,colname)
     values(@tablename,@colname)
 set @count=@count-1
    end
select * from #bb

drop table #aa
drop table #bb
drop table #cc