Software Applications Programming Errors and solutions.

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)