Keagan Dalley Keagan Dalley - 9 months ago 41
SQL Question

SQL Replace entire row with value

So I have a row in a table which contains 300 randomly generated hashes. I would like to replace all of them with one specific hash. How could I write a query that replaces every value in said table with my specific hash? Right now my query looks like:

SELECT TOP 1000 [Hash]
FROM [x].[y].[z]

X/Y/Z are different in my query obviously. However I do not know how I can then replace every value in the top 1000 Hashes with my specific hash.

UPDATE [x].[y].[z]
SET Hash = 'OneHashToRuleThemAll'

No WHERE condition will update the entire table. Make sure this is what you want.