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
38309 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

Can sql servers linked to other servers like oracle?

915

What is BCP? When does it used in sql server 2012?

1017

Which are new data types introduced in sql server 2008?

1010

What is stored in the mssqlsystemresource database? : sql server database administration

1001

What are the difference between primary keys and foreign keys?

935

What is ms sql server triggers?

973

Give main differences between "Truncate" and "Delete".

1053

Can you please explain the difference between function and stored procedure?

973

What is the user of Primary key?

937

What is a trigger? Why we need it?

958

How to find the version of sql server? : sql server database administration

1066

How to connect to SQL Azure Database by using sqlcmd?

136

What is cube dimension? : sql server analysis services, ssas

971

can SSRS reports Cache results?

144

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3836