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

by 


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