COUNT (Transact-SQL) - TechNet - Microsoft

Returns the number of items in a group. COUNT works like the COUNT_BIG function. The only difference between the two functions is their return values.

technet.microsoft.com