Create a gist now

Instantly share code, notes, and snippets.

@amarkulo /.sql
Created Aug 24, 2017

What would you like to do?
Check PwnedPwdDB for unsecure hashes
use PwnedPwdDB
go
DECLARE @HashThis varchar(MAX) = 'password';
DECLARE @Hash varchar(MAX);
set @Hash = convert(varchar(max), HASHBYTES('SHA1', @HashThis), 2);
select * from Hashes where hash = @Hash;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment