ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What is the datatype returned by count(*)
 Question Submitted By :: Kevin
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the datatype returned by count(*)
Answer
# 1		 
int
 
Is This Answer Correct ?    0 Yes 0 No
A
 
  Re: What is the datatype returned by count(*)
Answer
# 2		 
float
 
Is This Answer Correct ?    0 Yes 0 No
Suresh
 
 
 
  Re: What is the datatype returned by count(*)
Answer
# 3		 
count(*) return Int Data Type
 
Is This Answer Correct ?    0 Yes 0 No
Awi (focus)
 
  Re: What is the datatype returned by count(*)
Answer
# 4		 
count(*) returns the total number of not null values in 
given column
 
Is This Answer Correct ?    0 Yes 0 No
Thirumal
 
  Re: What is the datatype returned by count(*)
Answer
# 5		 
it returns how meny columns in the data table (or)
how meny records in the table
 
Is This Answer Correct ?    0 Yes 0 No
Haribabu
 
  Re: What is the datatype returned by count(*)
Answer
# 6		 
it returns int
 
Is This Answer Correct ?    0 Yes 0 No
Siva
 
  Re: What is the datatype returned by count(*)
Answer
# 7		 
The datatype returned by count(*) is INTEGER type.
 
Is This Answer Correct ?    2 Yes 0 No
Gunjan Sapra
 
  Re: What is the datatype returned by count(*)
Answer
# 8		 
It returns Integer data type.
since count function return the total count of a particular
fields.
 
Is This Answer Correct ?    1 Yes 0 No
Sathishrpillai
[Soft VAT Innovations]
 
  Re: What is the datatype returned by count(*)
Answer
# 9		 
The count(*) returns Integer Datatype.
 
Is This Answer Correct ?    1 Yes 0 No
Ramesh
 
  Re: What is the datatype returned by count(*)
Answer
# 10		 
Count(*) returns INT.
 
Is This Answer Correct ?    1 Yes 0 No
Vinod
 
  Re: What is the datatype returned by count(*)
Answer
# 11		 
Count(*) returns number of rows(counts) available in table. 
It returns Int datatype
 
Is This Answer Correct ?    1 Yes 0 No
Vikky
 
  Re: What is the datatype returned by count(*)
Answer
# 12		 
greater
 
Is This Answer Correct ?    0 Yes 1 No
Rkesav
 
  Re: What is the datatype returned by count(*)
Answer
# 13		 
int
 
Is This Answer Correct ?    1 Yes 0 No
Srinivas
 
  Re: What is the datatype returned by count(*)
Answer
# 14		 
ir returned Int datadtpe
 
Is This Answer Correct ?    1 Yes 0 No
Amar_chhatwani
 
  Re: What is the datatype returned by count(*)
Answer
# 15		 
Server.GetLastError().Message
 
Is This Answer Correct ?    0 Yes 1 No
Server.getlasterror().message
 
  Re: What is the datatype returned by count(*)
Answer
# 16		 
int data type
 
Is This Answer Correct ?    1 Yes 0 No
Krishna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is bit datatype and what's the information that can be stored inside a bit column?  1
What is the basic functions for master, msdb, tempdb databases? CSC2
Why we need a group by clause?  3
What are the different types of replication? How are they used?  3
Which stored procedure will you be running to add a linked server?  1
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs1
Difference between writing SQL query and stored procedure ? Cognizent8
Can you tell me the difference between DELETE & TRUNCATE commands?  10
When do you create cluster and noncluster index? Satyam4
Explain the architecture of SQL Server?  2
Display a roll having miminum marks in two subjects? Patni4
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?  1
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  2
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?  3
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz  6
what is the cursor life span? Evalueserve5
What are the two virtual tables SQL Server maintains for triggers?  2
What is the diff between Static Queries and Dynamic queries give me some examples CSC1
how to change column into row in sql  1
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM6
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com