Is triple des Encryption /Decryption Support in sq

问题:

For Example:

Here, Is this function EncryptByPassPharase() support in sql server 2000? If Not Then is there any function like that in sql server 2000? How Can I do same thing in sql server 2000?

INSERT INTO  login_details(username,password) VALUES('smith2',EncryptByPassPhrase('12','XXX'))

回答1:

No, the function EncryptByPassPharase() is not support for SQL Server < 2008. On microsoft doc has been detail about it. You can se more detail here ENCRYPTBYPASSPHRASE