Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
The COUNT function counts the number of cells in a column that contain numbers.
The only argument allowed to this function is a column. You can use columns containing any type of data, but only numbers are counted. The COUNT function counts rows that contain the following kinds of values:
If the row contains text that cannot be translated into a number, the row is not counted.
When the function finds no rows to count, it returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
The following example shows how to count the number of numeric values in the column, ShipDate.
To count logical values or text, use the COUNTA or COUNTAX functions.