simple certificate and symmetric key.sql

CREATE DATABASE QuickTest

GO

USE QuickTest;
GO

CREATE CERTIFICATE SelfSignedCertificate   
   ENCRYPTION BY PASSWORD = 'helloiamapassword123'  
   WITH SUBJECT = 'Self Signed Cert Test',   
   EXPIRY_DATE = '20900101';  
GO  

CREATE SYMMETRIC KEY SymmetricKeyHiHi   
WITH ALGORITHM = AES_256  
ENCRYPTION BY CERTIFICATE SelfSignedCertificate;  
GO