eclare @SQLCmd varchar(max);

select
    @SQLCmd = (select 'UPDATE STATISTICS ' + object_name(object_id) + ' with fullscan;' + char(13) + char(10)
               from
                   sys.tables
               for xml path (''),type).value('.','varchar(max)');

print @SQLCmd;
exec (@SQLCmd);