The COUNT_BIG function
By SQLRx Admin | Miscellaneous , SQL Server , Tip of the Month
SQL Server Development: The COUNT_BIG function is used much like the COUNT function to return the number of items in a group. COUNT_BIG returns a bigint data type and has a maximum value returned of 9,223,372,036,854,775,807. COUNT returns an int data type and has a maximum value returned of 2,147,483,647. COUNT_BIG is useful for rowcounts […]
Continue reading