It will return INT. Proof is here... SELECT COUNT(*) AS Total INTO tmpArch

What is the datatype returned by count(*)

Question Posted / lakshmi narayanan r

22 Answers
39049 Views
247Customer, Asian CERC, I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What will be the maximum number of indexes per table?

962

Can coalesce return null?

1016

What is difference between line feed ( ) and carriage return ( )?

908

What is de-normalization in sql database administration? Give examples?

985

Give me any three differences between Truncate and Delete.

1107

What is a periodical index?

928

What are the types of ssrs?

145

define and explain the differences between clustered and non-clustered indexes.

1196

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

What is instead of trigger sql server?

1002

What are the new features are introduced in sql server 2012 reporting services?

149

Does transparent data encryption provide encryption when transmitting data across the network?

1048

What is amo? : sql server analysis services, ssas

1089

What is the difference between having clause and where clause in sql server?

1100

What is attribute? : sql server analysis services, ssas

1020