Hi Loudy, everybody,
Thanks for the interest.
The SQL looks like that:
====================================================
=== Encrypting ===
-- Open symmetric key
open symmetric key UserKey decryption by password = 'P@ssw0rd'
---- Add encrypted data
insert into
[Target]
(Column1
,Column2)
select
Column11
,ENCRYPTBYKEY(key_guid('UserKey'),Column12,1,Column11)
from
[Source]
-- Close symmetric...