当我尝试做如下：
SELECT SUM(bitColumn) FROM MyTable;
我得到错误：
Operand data type bit is invalid for sum operator.
SELECT SUM(CAST(bitColumn AS INT)) FROM dbo.MyTable
需要投入数量
或另一种解决方案
SELECT COUNT(*) FROM dbo.MyTable WHERE bitColumn = 1
