CREATE SYMMETRIC KEY dxclubkey WITH ALGORITHM=DES
ENCRYPTION BY PASSWORD='dxerp.net@123456789'
GO /*创建密钥*/
OPEN SYMMETRIC KEY dxclubkey
DECRYPTION BY PASSWORD='dxerp.net@123456789' /*打开密钥*/
DECLARE @str NVARCHAR(100),@Encrypted VARBINARY(MAX)
SET @str=N'1232323333232332333562.12'
SELECT @Encrypted=ENCRYPTBYKEY(KEY_GUID('dxclubkey'),@str) /*加密*/
SELEcT '加密'=@Encrypted ,'解密'=CAST(DECRYPTBYKEY(@Encrypted) AS NVARCHAR(100)) /*解密*/
print @Encrypted
CLOSE SYMMETRIC KEY dxclubkey
GO
go
DROP SYMMETRIC KEY dxclubkey
GO
ENCRYPTION BY PASSWORD='dxerp.net@123456789'
GO /*创建密钥*/
OPEN SYMMETRIC KEY dxclubkey
DECRYPTION BY PASSWORD='dxerp.net@123456789' /*打开密钥*/
DECLARE @str NVARCHAR(100),@Encrypted VARBINARY(MAX)
SET @str=N'1232323333232332333562.12'
SELECT @Encrypted=ENCRYPTBYKEY(KEY_GUID('dxclubkey'),@str) /*加密*/
SELEcT '加密'=@Encrypted ,'解密'=CAST(DECRYPTBYKEY(@Encrypted) AS NVARCHAR(100)) /*解密*/
print @Encrypted
CLOSE SYMMETRIC KEY dxclubkey
GO
go
DROP SYMMETRIC KEY dxclubkey
GO