In T-SQL, aggregate functions(ex. COUNT(), SUM()) return NULL value or raise Error if all values are NULL or no rows. Here’s query count rows correctly even if all column values are NULL or no rows hit. — Count rows(exclude NULL value)…
In T-SQL, aggregate functions(ex. COUNT(), SUM()) return NULL value or raise Error if all values are NULL or no rows. Here’s query count rows correctly even if all column values are NULL or no rows hit. — Count rows(exclude NULL value)…