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
38943 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 is the synonym of join?

957

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1985

How to backup encryption key ?

182

What are the purposes and advantages stored procedure?

954

Is sql server 2016 free?

935

Explain optimistic and pessimistic concurrency?

991

How to add additional conditions in SQL?

1022

Why truncate is ddl?

1084

How to create a simple table to test triggers in ms sql server?

973

Define synonym?

1168

How to create user defined functions with parameters?

1224

What does REVERT do in SQL Server 2005?

956

What are the different types of replication you can set up in sql server?

1047

How do you implement session management in SQL Server mode?

1097

What happens to a trigger with multiple affected rows?

938