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

How to create “dependant” parameter “make, model, year”

133

Tell me when is the update_statistics command used?

1118

Name the different type of indexes in sql?

967

Can a database be shrunk to 0 bytes, if not, why?

1110

When we should use and scope of @@identity?

999

How to use copy and concatenate commands in SQL?

1145

How many partitions a clustered index has by default in sql server 2012?

1091

Describe in brief sql server monitoring ways.

1054

What are the disadvantages of using querystrings to send data from one page to another?

1008

Explain the first normal form(1nf)?

1033

Do you have any idea about the tcl commands?

967

What is the distinction amongst delete and truncate?

1072

Determine when to use stored procedure to complete sql server tasks?

1059

What is user-defined multi-statement table-valued function?

1072

How do you set a trace flag in sql server?

1041