What is more appropriate sp_updatestats or UPDATE STATISTICS?
Couple of things ..


Stop using the undocumented sp_MSforeachtable
From Erin's blog - Understanding What sp_updatestats Really Updates


  sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows



Note that sp_updatestats in the code sp_helptext sp_updatestats, it runs 'UPDATE STATISTICS '



Recommendation:


Use Ola's Index maintenance solution