Feb 13, 2014

SQL Server: Updating A Column With Random Lookup Values

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.