SQL Server Error Msg 10723 – In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form ‘SET @variable = column = expression’ are not valid in the SET clause of an UPDATE action in a MERGE statement. Modify the SET clause to only specify assignments of the form ‘SET @variable = column’ or ‘SET @variable = expression’.

In this blog post, let’s learn about the error message “10723 – In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form ‘SET @variable = column = expression’ are not valid in the SET clause of an UPDATE action in a MERGE statement. Modify the SET clause to only specify assignments of the form ‘SET @variable = column’ or ‘SET @variable = expression’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

10723 – In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form ‘SET @variable = column = expression’ are not valid in the SET clause of an UPDATE action in a MERGE statement. Modify the SET clause to only specify assignments of the form ‘SET @variable = column’ or ‘SET @variable = expression’.

Reason for the Error

To be update soon…

Solution

To be update soon…