Count rows from a table when row is greater than > 2,147,483,647 (or max Int Range)

Virendradugar
Posted by Virendradugar under Sql Server category on | Views : 2563
Select Count_Big(*) From tableName


Count_big returns the number of items in a group. COUNT_BIG works like the COUNT function. The only difference between the two functions is their return values. COUNT_BIG always returns a bigint data type value. COUNT always returns an int data type value.

Comments or Responses

Login to post response