In SQL Server 2000, Query: ------ select count from employees Answer:

The Difference between 'Count' and 'Count(*)'

Question Posted / selvaraj.v

13 Answers
29093 Views
I also Faced
E-Mail Answers

Answer Posted / selvaraj.v

In SQL Server 2000,
Query:
------
select count from employees
Answer:
------
invalid column name 'count'

In SQL Server 2000,
Query:
------
select count(*) from employees

Answer:
-------
No column name
----------------
1. 20

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain mixed authentication mode of sql server?

1115

How would you add a section to a table?

1107

When we should use and scope of @@identity?

1041

How check triggers in sql server?

1047

What is read committed?

1169

How you can get a list of all the table constraints in a database?

997

Is foreign key a primary key?

1174

What command is used to delete a table from the database in the sql server and how?

1185

Explain the microsoft sql server delete command? : SQL Server Architecture

1146

What are the three different part of rdl file explain them?

274

What is enhanced database mirroring in sql server 2008?

1033

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2058

What are the new features of sql server 2012 reporting service?

141

Mention the uses of stored procedures.

1006

Difference between drill down and drill through report.

1003