--从字段为'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