SQL加密与密钥 SQL代码

-- Use the AdventureWorks database 
   USE AdventureWorks; 

-- Create a Database Master Key   创建密钥

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'p@ssw0rd';

-- Create a Temp Table    创建一个临时表

CREATE TABLE Person.#Temp 
(
ContactID INT PRIMARY KEY,
FirstName NVARCHAR(200),
MiddleName NVARCHAR(200), 
LastName NVARCHAR(200),
eFirstName VARBINARY(200),
eMiddleName VARBINARY(200), 
eLastName VARBINARY(200)
); 




-- Create a Test Certificate， encrypted by the DMK  创建证书加密

CREATE CERTIFICATE TestCertificate
WITH SUBJECT = 'Adventureworks Test Certificate', 
EXPIRY_DATE = '10/31/2012';