ニュース

Ars Technica20年

TSQL: How can I deal with blank (but not NULL) fields for SUM()?

I'm trying to put together a summary page for a db a customer has, and I'm trying to simply use SUM() to add up the fields as follows:SELECT SUM(CONVERT(numeric, ISNULL(Planned, 0))) AS Planned ...