What is the datatype returned by count(*)

Answer Posted / siva

it returns int

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

623


What is indexing explain it with an example?

555


What is sql server query analyzer?

515


What is the difference between online clustering and Offline clustering?

1922






What is the command to change the recovery model?

571


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

550


How to find the service pack installed? : sql server database administration

554


What is #table in sql server?

539


What are different types of schemas?

523


How many triggers are possible per table?

630


What is a linked server in sql server?

577


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

551


What do you know about system database? : SQL Server Architecture

499


What is function of ROLLUP ?

658