I have implemented SQL Symmetric key encryption by using the below scripts in SQL Server 2016.
CREATE CERTIFICATE EmpEncryptionCertificateWITH SUBJECT = 'Column-level encryption certificate',EXPIRY_DATE = '20191231'; GOCREATE SYMMETRIC KEY EmpSymmetricKeyWITH ALGORITHM = AES_256ENCRYPTION BY CERTIFICATE EmpEncryptionCertificateGO