Recollect stats by database after patch upgrade rollback

Database
Enthusiast

Recollect stats by database after patch upgrade rollback

Does anyone out there have some dynamic sql that will script stats collection from a PROD database to be applied to a TEST database? We had to rollback a patch upgrade and I lost all my stats in the TEST environment.