SQL Server Error Msg 33278 – Cannot assign the same encryption scheme to two expressions at line ‘%d’. The encryption scheme of the first expression is %ls and the encryption scheme of the second expression is %ls. Other columns/variables with the same encryption scheme as the first expression are: %.*ls. Other columns/variables with the same encryption scheme as the second expression are: %.*ls.

In this blog post, let’s learn about the error message “33278 – Cannot assign the same encryption scheme to two expressions at line ‘%d’. The encryption scheme of the first expression is %ls and the encryption scheme of the second expression is %ls. Other columns/variables with the same encryption scheme as the first expression are: %.*ls. Other columns/variables with the same encryption scheme as the second expression are: %.*ls.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

33278 – Cannot assign the same encryption scheme to two expressions at line ‘%d’. The encryption scheme of the first expression is %ls and the encryption scheme of the second expression is %ls. Other columns/variables with the same encryption scheme as the first expression are: %.*ls. Other columns/variables with the same encryption scheme as the second expression are: %.*ls.

Reason for the Error

To be update soon…

Solution

To be update soon…