(─━┘_└━─)/ 머리만1톤(Head1Ton)

IF OBJECT_ID('TEMPDB..#SECRETINFO') IS NOT NULL

 DROP TABLE #SECRETINFO

CREATE TABLE #SECRETINFO (SECRET VARBINARY(8000) NOT NULL)

GO

INSERT INTO #SecretInfo

 SELECT

  EncryptByPassPhrase('sqlleader','123456')

GO

SELECT * FROM #SECRETINFO

GO

SELECT CAST(DecryptByPassPhrase('sqlleader',Secret) as varchar(50))

FROM #SecretInfo

GO