I'm sure this is an easy one for you database gurus :)
I added Column3 to existing Table1 as a FK, which is the PK for a new Table5 I added. When I added the column to Table1, it populated the values as NULL, so it won't let me INSERT values (I normally do a BULK INSERT from CSV).
I am obviously not a database expert :), so what is the simplest way to update the NULL values to a list of real values? If an advanced statement is needed, great, but please start simple to help me understand how/why.