[Solved] SQL Server, replace value of column A with value of column B, and value of column B with value of column A
UPDATE whatever_your_table_is_called SET seconddescription = longdescription ,longdescription = seconddescription solved SQL Server, replace value of column A with value of column B, and value of column B with value of column A