SQL Server Error Code – 10723 in a merge statement, a variable cannot

In this blog post, you’ll learn more about the SQL Server Error Code 10723 and the error message description that is shown

SQL Server Error Code

10723

SQL Server Error Description for the Code :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’.