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 mean by crystal repoart? ahere we will mainly use that?

1 Answers  

What do you need to connect php to sql server?

0 Answers  

What is primary key and example?

0 Answers  

Explain time data type in sal server 2008?

0 Answers  

What is efficiency data?

0 Answers  

What is the use of partition by in sql server?

0 Answers  

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

What are the triggers in sql?

0 Answers  

How many triggers are possible per table?

0 Answers  

Can you pass expressions to stored procedure parameters?

0 Answers  

How to connect a database with sql express.?

0 Answers   MCN Solutions,

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers