Sql Server Management Studio / Always Encrypted Parametrization
The order of the parameters in SSMS (v.17.9.1) seems to be critical when using encrypted and not encrypted columns in one statement.
Declaring the not encrypted variable before encrypted vars works, the other way it doesn't work (ERROR: ncryption scheme mismatch for columns/variables .. see more details and example in the file attached.)
Thanks for the reporting the issue. We’ll take a look at it and prioritize accordingly.