Answer / krishna

int data type

Answer / harsh

SELECT COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 55000;

It would return the following result set:
Number of employees
5
HENCE IT RETURNS 'INT' TYPE.

Answer / sanjeev kumar

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

Answer / sujatha_k

number data type is return.

Answer / thirumal

count(*) returns the total number of not null values in
given column

Answer / amar_chhatwani

ir returned Int datadtpe

Answer / lakshmi narayanan r

It will return INT. Proof is here...
SELECT COUNT(*) AS Total INTO tmpArchiveStoreMaster1 FROM
ArchiveStoreMaster asm
GO
sp_help tmpArchiveStoreMaster1

Name

Owner

Type
Created_datetime
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
------------------------------- -----------------------
tmpArchiveStoreMaster1

dbo

user table 2010-07-06
15:43:05.310



Column_name

Type

Computed Length
Prec Scale Nullable
TrimTrailingBlanks FixedLenNullInSource
Collation
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
----------------------------------- ----------- ----- -----
-----------------------------------
-----------------------------------
-----------------------------------
--------------------------------------------------------------------------------------------------------------------------------
Total

int

no 4
10 0 yes (n/a)
(n/a)
NULL

Answer / vikneswaran

number

Answer / haribabu

it returns how meny columns in the data table (or)
how meny records in the table

Answer / server.getlasterror().message

Server.GetLastError().Message

What is the difference between constraints and triggers?

9 Answers   Wipro,

explain different types of jions with examples briefly?

1 Answers   Zensar,

What's the difference between a primary key and a unique key?

4 Answers  

How to Check if table exists in sql server?

0 Answers  

optimization techinques

0 Answers   Wipro,

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

What are the triggers in sql?

0 Answers  

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

How to view the error log for any specific instance? : sql server database administration

0 Answers  

What happens when converting big values to numeric data types?

0 Answers  

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,