연구개발/DBA

간단한 암호화 복호화

HEAD1TON 2009. 7. 29. 02:40


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
 


저작자표시 (새창열림)