DIfference between MD5,MD4,SHA1,SHA2 algorithms in HASH_BYTES() Function In T-sql

Can any one help me out in understanding what really is the diff开发者_StackOverflow社区erence between SHA1,SHA2,MD4 and MD5 algorithms in terms of data of a table.

Which is the precise situation to opt which algorithm. ?

How HASH_BYTES() treats each Algorithm?

Please Help

Thanks n Regards

Does this help: http://en.wikipedia.org/wiki/Comparison_of_cryptographic_hash_functions

MD4 and MD5 should not be used at all, both are severely broken. SHA1 is teoretically broken, so its not recommended to use as well. From the mentioned algorithms only SHA2 should be used.

Edit: SHA1 is now proven to be broken by a practical attack