Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Which Function is used to count more than two billion rows in a table?
on 9/4/2009 | Category:
Sql Server Interview questions
| Views: 27705
Select from following answers:
1) and 2)
The COUNT_BIG function is identical to the COUNT function, but returns a BIGINT data type, whereas COUNT returns an INT. The upper limit for INT data type is 2 billion; therefore if you anticipate counting more than two billion rows use the COUNT_BIG function. Any attempt to use the COUNT function when counting over 2 billion rows returns an error.
Show Correct Answer
Many Interviews |
< Previous :
How turn off cookies for one page in your site?
Next > :
In a connection-oriented socket, Which Protocal is ...
Comments or Responses
Login to post response
More Interview Questions by Syedshakeer
In a connection-oriented socket, Which Protocal is used to establish a ...
Machine.config will be created automatically when you
In which Event all the Controls will be loaded(in asp.net)?
What will be the output for the following: String str1="Hello&qu ...
To send Emails,you need the following classes from the System.Web.Mail ...
AJAX applications are
Which of the follwoing code have to write for cancel Link in gridview?
Which of the follwoing property has the default property for gridview ...
Latest Interview Questions
How do you determine the maximum nested-level of Stored Procedure ?
Difference between new and override keyword?
What is 'NEXT USED' in SQL Server ?
A table can have maximum of 1024 partitions.
How do you explicitly kill a user session?
What is the maximum number of cookies that can be allowed to a web sit ...
Name two properties common in every validation control?
Which is the first event in page life-cycle Event?