SQL Server Count Function

Can Any One Tell me how range开发者_如何转开发 if Count(*) in SQL Server i.e How much rows it count Return. when to use big_count() in SQL Server

Thank u Dinesh

---

COUNT returns an INTEGER so max value is: 2,147,483,647
COUNT_BIG returns a BIGINT so max value is: 9,223,372,036,854,775,807

INT/BIGINT datatype reference