What is the datatype returned by count(*)

Answer Posted / sanjeev kumar

It will return Int or Bigint depend on the size of the row.
(But both are same)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of indexes?

613


Call by value and call by reference in procedure and function, with NOCOPY.

844


How many databases instances are there in sql server 2000?

583


What is service broker? : sql server database administration

587


Is it possible to replicate data from sql server to oracle? : sql server replication

549






What is the difference between a clustered index and a non-clustered index?

536


What are the differences between DDL, DML and DCL in SQL?

758


Explain the Ways to improve the performance of a sql azure database?

64


What is sql server used for?

558


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

529


What are the different sql server versions?

521


What is xdr?

569


What is a collation in ms sql server?

552


Explain the difference between primary keys and foreign keys?

517


Define outer join in sql server joins?

533