LitKnd · February 24, 2020 20:21
diff --git a/simple certificate and symmetric key.sql b/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
	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