On a SQL server 2012 I have to do a massive update (record by record) of a column A in table X based on the value that same column has in table Y. The key is a serial number, How can I do this?
On a SQL server 2012 I have to do a massive update (record by record) of a column A in table X based on the value that same column has in table Y. The key is a serial number, How can I do this?
According to comments, this would be the query:
UPDATE tx SET tx.A=ty.A
FROM x AS tx
INNER JOIN Y AS ty
ON tx.Key=ty.Key