set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[ETL_Encrypt] (@inputcolumn VARCHAR(200), @outputcolumn VARCHAR(max), @transtable VARCHAR(max)) AS DECLARE @SQL VARCHAR(MAX) BEGIN SET @SQL= 'OPEN SYMMETRIC KEY TestTableKey DECRYPTION BY CERTIFICATE EncryptTestCert ' --OPEN SYMMETRIC KEY TestTableKey DECRYPTION BY CERTIFICATE EncryptTestCert PRINT @SQL EXEC(@SQL) SET @SQL= 'UPDATE '+ @transtable +' SET '+ @outputcolumn +'= ENCRYPTBYKEY(KEY_GUID(''TestTableKey''),convert(varbinary,'+ @inputcolumn +'))' --UPDATE TestTable SET EncryptSecondCol = ENCRYPTBYKEY(KEY_GUID('TestTableKey'),SecondCol) PRINT @SQL EXEC(@SQL) SET @SQL= 'CLOSE SYMMETRIC KEY TestTableKey ' --CLOSE SYMMETRIC KEY TestTableKey PRINT @SQL EXEC(@SQL) END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)