EncryptByPassPhrasePwd：
USE [cecaopsys]
GO
/****** Object: UserDefinedFunction [dbo].[EncryptByPassPhrasePwd] Script Date: 07/12/2017 17:17:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
//-----------加密函数----------- ALTER FUNCTION [dbo].[EncryptByPassPhrasePwd](@password nvarchar(50)) RETURNS varbinary(max) AS BEGIN declare @pwd varbinary(max) SELECT @pwd = EncryptByPassPhrase( ‘EPdRc2‘, @password) return @pwd END;
DecryptByPassPhrasePwd：
USE [cecaopsys]
GO
/****** Object: UserDefinedFunction [dbo].[DecryptByPassPhrasePwd] Script Date: 07/12/2017 17:39:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
//---------解密函数---------- ALTER FUNCTION [dbo].[DecryptByPassPhrasePwd](@password varbinary(max)) RETURNS nvarchar(max) AS BEGIN declare @pwd nvarchar(max) SELECT @pwd =CAST( DecryptByPassPhrase(‘EPdRc2‘,@password) as nvarchar(max)) return @pwd END
原文：https://www.cnblogs.com/whatarewords/p/10712144.html