What is the datatype returned by count(*)

Answer Posted / vikky

Count(*) returns number of rows(counts) available in table.
It returns Int datatype

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to set a database state to offline in ms sql server?

534


What is difference statement and preparedstatement?

546


Which sql server is best?

514


What does indexation mean?

527


Explain where clause?

535






is there a column to which a default can't be bound? : Sql server database administration

535


What is the importance of three tier architecture?

607


What is measure group, measure? : sql server analysis services, ssas

547


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

534


How to insert multiple rows with a subquery?

528


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

547


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

482


What are different types of replication in sql server?

566


What are Spatial data types in SQL Server 2008

552


Can you explain different types of locks in sql server?

523