What is the use of Count_Big() function in SQL Server

Options :
  1. Return the Boolean value
  2. Return the total number of records in in Int
  3. Return the total number of records in in Big Int
  4. There is no such function in T-SQL
Answer and Explanation :-

Answer: Option 3

Explanation:

COUNT_BIG() is an aggregate built function in SQL Server which will return the total number of records in a form of Big Integer

How do you rate this queston?  Very Easy  Easy  Average  Above Average  Tough

Previous Question : How to reset the identity column in SQL Server?

Next Question : From Which version COUNT_BIG() function is included in SQL Server

Click here for online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:-








The key to your happiness is to own your slippers, own who you are, own how you look, own your family, own the talents you have, and own the ones you don't. If you keep saying your slippers aren't yours, then you'll die searching, you'll die bitter, always feeling you were promised more. Not only our actions, but also our omissions, become our destiny.
-Abraham Verghese Cutting for Stone