How can I use SUM for bit columns?

May 5, 2023 by Tarik

SELECT SUM(CAST(bitColumn AS INT))
FROM dbo.MyTable

need to cast into number

or another solution –

SELECT COUNT(*)
FROM dbo.MyTable
WHERE bitColumn = 1