Modify multiple column values in single query in sql

To update multiple column values in single shot query in sql you can take help from below query.

UPDATE TestTable
SET (Col1, Col2, Col3, Col4) = (SELECT a, b, c, d FROM TestTable2 WHERE id =TestTable.Col5)

Comments