Keagan Dalley Keagan Dalley - 1 year ago 100
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.

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

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download