SQL根据字段值查找表及字段

方法一、
declare  @str  varchar(100)  
set  @str='351864040889572'    --要搜索的字符串  
 
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

方法二（用下面这个存储过程）
首先
create  proc [dbo].[search_db]
    @table nvarchar(100),
    @cond nvarchar(512)
as
declare hCForEach cursor global for
select sqlstmt =
'if exists (' + stmt + ')