I want to know how to pass symmetric key to SQL Query as parameter.
I’m usually using hardcode within the query as follows
OPEN SYMMETRIC KEY SymKey DECRYPTION BY CERTIFICATE CertiFi; SELECT * FROM MasterBlaster CLOSE SYMMETRIC KEY SymKey
I want to pass it as parameter.