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

What is the datatype returned by count(*)

Question Posted / vikky

Answer Posted / vikky

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

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which is better statement or preparedstatement?

866

Explain the difference between functions and stored procedures in sql server?

918

Explain data warehousing in sql server?

988

What is named query? : sql server analysis services, ssas

907

Can a function call a stored procedure in sql server?

908

How to disable stored procedure sql server?

1524

How sql server enhances scalability of the database system?

1108

How do I view a stored procedure in sql server?

943

Does group by or order by come first?

900

How to get @@error and @@rowcount at the same time?

983

What is 2nf in normalization?

943

Does sql server 2000 clustering support load balancing?

903

Why does sql studio use a single registered database repository? : sql server management studio

950

What are trace flags?

958

What does it mean to normalize data?

894