0

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 about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- 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

view current version

edited may 9 11

created may 9 11 PleaseStand