Beyond SHA1: Using HASHBYTES for Secure Hashing in MS SQL (with Caution)
Deprecated: HASHBYTES with algorithms like SHA1 and MD5 is deprecated since SQL Server 2016. It's recommended to use the stronger and more secure alternatives like SHA2_256 or SHA2_512 whenever possible