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...