交换SQL Server中同一表中两行的值

如果要将两个已知ID的值从一行交换到另一行，请尝试以下操作：

--need to store the original valuesSELECt    *,CASE WHEN id=123 then 987 ELSE 123 END AS JoinId    INTO #Temp    FROM YourTable    WHERe ID in (123,987)--swap valuesUPDATe y    SET col1=t.col1        ,col2=t.col2    FROM YourTable        y        INNER JOIN #Temp  t ON y.id =t.JoinId    WHERe ID in (123,987)