I want to use SQL Server Always Encrypted with Nintex SQL command. This new feature requires the client driver to know the exact type of the given parameters. Thus it is advised to use SQLParameter to append to SQLCommand and not to pass the whole SQLCommand as a string to the SQLServer. We are looking for a solution to solve this.
Example what I currently do, without exact syntax to any programing language:
SQLCommand = „EXEC dbo.TestStoreProcedure @TestParameter = 1”
What I need to achieve:
SQLCommand = „dbo.TestStoreProcedure”
SQLParameter = SQLPARAMETER(@TestParameter, 1, FLOAT)
See this article as example: https://msdn.microsoft.com/library/mt637351.aspx
Do you have any advise or experience?