4

Please login or register to vote for this query.

(click on this box to dismiss)

Looks up all accounts set to use the given email address by comparing email hashes.

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- Find a user by email address
-- Looks up all accounts set to use the given email address by comparing email hashes.

declare @hash varchar(32) = substring(master.dbo.fn_varbintohexstr(
    hashbytes('md5', lower(ltrim(rtrim('##EmailAddress##'))))
), 3, 32)

select Id as [User Link] from Users where EmailHash = @hash

fork query

edited mar 9 12 CodeInChaos

created may 9 11 PleaseStand