It’s handy syntax. just a reminder for myself, as I don’t use sql often.
UPDATE [SiteUsr] SET HashAlgorithm = CASE WHEN LEN(PwdHsh) <= 32 THEN 'MD5' ELSE 'SHA1' END
It’s handy syntax. just a reminder for myself, as I don’t use sql often.
UPDATE [SiteUsr] SET HashAlgorithm = CASE WHEN LEN(PwdHsh) <= 32 THEN 'MD5' ELSE 'SHA1' END