Select * from *

select o.name as [nom_table], c.name as [nom_champ]
from sysobjects o, syscolumns c 
where o.type='U'

select nom_table, nom_champ
from table_temp
where nom_champ[n] = 'valeur'

create procedure RechercheChamp
@recherche varchar(255)
as

    DECLARE tnames_cursor CURSOR
    FOR
    select name from sysobjects o where o.type='U'
    OPEN tnames_cursor
    DECLARE @name sysname
    FETCH NEXT FROM tnames_cursor INTO @name
    WHILE (@@FETCH_STATUS <> -1)
    BEGIN
    -------------------+
        declare @requete varchar (8000)
        set @requete='SELECT * FROM '+@name+' where '

        declare @requeteFiltre varchar (8000)
        set @requeteFiltre=''
       
        DECLARE tnames_cursorFiltre CURSOR
        FOR
        SELECT   COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=@name
        OPEN tnames_cursorFiltre
        DECLARE @COLUMN_NAME sysname
        FETCH NEXT FROM tnames_cursorFiltre INTO @COLUMN_NAME
        WHILE (@@FETCH_STATUS <> -1)
        BEGIN
        -------------------
            if @requeteFiltre<>''
                set @requeteFiltre= @requeteFiltre+ ' OR '

            set @requeteFiltre  = @requeteFiltre + 'convert(varchar(255),'+@COLUMN_NAME+') like ''%'+@recherche+'%''';


        -------------------
        FETCH NEXT FROM tnames_cursorFiltre INTO @COLUMN_NAME
        END
        CLOSE tnames_cursorFiltre
        DEALLOCATE tnames_cursorFiltre

        exec (@requete + @requeteFiltre)

    -------------------
    FETCH NEXT FROM tnames_cursor INTO @name
    END
    CLOSE tnames_cursor
    DEALLOCATE tnames_cursor