cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
d_kalmar
Nintex Newbie

SQL Server 2016 Always Encrypted Nintex SQL Command

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?

Thanks,

0 Kudos
Reply