[Solved] SQL Server, replace value of column A with value of column B, and value of column B with value of column A

by

[ad_1]

UPDATE whatever_your_table_is_called
SET    seconddescription = longdescription
      ,longdescription = seconddescription

[ad_2]

solved SQL Server, replace value of column A with value of column B, and value of column B with value of column A