This article explains how to update a table column with random values from another (lookup) table in SQL Server.
For example, Country table has two columns CountryID, CountryName and UserInfo table has CountryID column. We will update UserInfo table with random CountryIDs from Country table.