Search all table, all columns for a specific ( numeric ) value is SQLServer

search.sql

declare @serchval varchar(20) = '12347'
declare @table_name varchar(max), @col_name varchar(max),@sql varchar(max)
create table  #results (table_name varchar(100), column_name varchar(100))
declare crunch_all cursor forward_only for
select  t.table_schema+'.'+t.table_name table_name,c.COLUMN_NAME col_name from INFORMATION_SCHEMA.TABLES t
inner join INFORMATION_SCHEMA.COLUMNS c on c.TABLE_NAME = t.TABLE_NAME and c.TABLE_SCHEMA = t.TABLE_SCHEMA
where c.DATA_TYPE in ('int','decimal','smallint','float','real')


open crunch_all  
fetch next from crunch_all into @table_name,@col_name  

while @@FETCH_STATUS = 0  
begin  
      SET @sql = 'select '''+ @table_name+''''+','+''''+@col_name+''''+' from '+@table_name +' where '+@col_name+' ='+@serchval
	  --print @sql
	  insert into #results
	  exec(@sql)
	  fetch next from crunch_all into @table_name,@col_name 
	  
end 

close crunch_all  
deallocate crunch_all 
select * from #results
drop table #results