August 26, 2011

COUNT_BIG in SQL Server

It returns the total number of items in a group.We have total six records in a table.
 
image

The basic difference between COUNT_BIG(*) and well known COUNT(*) is former always
returns bigint datatype while later returns int datatype value.

That’s It
Enjoy Learning.

No comments:

Post a Comment