SQL - NEWID() producing the same guid on an update query
<p>In a table I have created a new column that's going to hold a randomized alphanumeric string. I've been using the NEWID() function. From my understanding, NEWID should just create a new guid per row but all my rows end up with the same guid.</p>

<p>My code is:</p>

<pre><code>DECLARE @random_guid
SET @random_guid = NEWID()
UPDATE this_table
SET random_column = @random_guid
</code></pre>

<p>Thanks in advance for any help!</p>