Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questioncreate 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