Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 38032 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
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is an identity column in insert statements?
We need to perform what steps in the following order to work with a cursor?
How to create a view using data from another view?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Can we do dml on views?
how many type of indexing in database?
What is triggers and stored procedures?
What is the concept of optimization?
What is a domain constraint give an example?
How to check if stored procedure is running in sql server?
What is a mixed extent?
What are the different types of backups that exist?
Describe and explain about SQL native client?
What are types of subqueries?
