1 use [pratice] 
2 go 
3 
4 CREATE ASYMMETRIC KEY asymDemoKey --创建非对称密钥名称 
5 WITH ALGORITHM = RSA_512 --加密安全类型 
6 ENCRYPTION BY PASSWORD = '123!' --密码 

 1 use [pratice] 
 2 go 
 3 
 4 --创建需要加密的数据 
 5 Create Table BankUser 
 6 (PKID int primary key identity(1,1) 
 7 ,UserNo varbinary(1000) null  --一定要用二进制数据类型
 8 ,CurState datetime   not null 
 9 ) 
10 go 
11 
12 insert into BankUser 
13 (UserNo,CurState) 
14 VALUES (EncryptByAsymKey(AsymKey_ID('asymDemoKey'),'137'),GETDATE()) 
15 --插入一条记录，字段UserNo存储了加密的号码值 
16 go
17 
18 
19 
20 --查看未加密的数据：  
21 SELECT PKID,Curstate, 
22 cast 
23 (DecryptByAsymKey(AsymKey_ID('asymDemoKey'),UserNo,N'123') 
24 as varchar(1000)) as UserNo --需要原始私钥 
25 from BankUser