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 do you understand by the data quality services in sql server?

0 Answers  

What is a db view?

0 Answers  

What are the different types of joins and what does each do?

2 Answers  

which table keeps the locking information? : Sql server administration

0 Answers  

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

How do you delete a data source?

0 Answers  

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

Explain indexed view?

1 Answers  

What is isolation levels?

0 Answers  

What is use of except clause? How does it differ from not in clause?

0 Answers  

Explain the purpose of indexes?

0 Answers