您可以使用具有预先计算的汉明权重的助手表来获取较小的数字（例如字节），然后相应地拆分值，加入助手表并获得部分汉明权重之和作为该值的汉明权重：
-- define Hamming weight helper tableDECLARE @hwtally TABLE (byte tinyint, hw int);INSERT INTO @hwtally (byte, hw) VALUES (0, 0);INSERT INTO @hwtally (byte, hw) SELECt 1 - byte, 1 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 3 - byte, 2 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 7 - byte, 3 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 15 - byte, 4 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 31 - byte, 5 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 63 - byte, 6 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 127 - byte, 7 - hw FROM @hwtally;INSERT INTO @hwtally (byte, hw) SELECt 255 - byte, 8 - hw FROM @hwtally;-- calculateWITH split AS ( SELECt SUBSTRINg(@value, number, 1) AS byte FROM master.dbo.spt_values WHERe type = 'P' AND number BETWEEN 1 AND LEN(@value))SELECt Value = @value, HammingWeight = SUM(t.hw)FROM split s INNER JOIN @hwtally t ON s.byte = t.byte
