Sep 13, 2018 05:36 AM|Brando ZWZ|LINK
Hi smtaqi ,
As far as I know, if you send plaintext to the SP, it will show this error.
Since you have already set the Amount SQL Server expects the value targeting the Amount
column to be encrypted, not in plaintext.
So you couldn't set the encrypted value to plaintext, it will show this error.
If you are using Sql Server Management Studio to execute your stored procedure, I suggest you could enable Parameterization for Always Encrypted.
More details about how to enable the Parameterization , you could refer to below article.