select count(*) from tablename.

How do you find the number of rows in a table?

Question Posted / hokar

Answer Posted / hokar

Is This Answer Correct ?

27 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how to create “alternate row colour”?

146

Does a sql server 2005 select statement require a from?

1001

How to create a user name in a database?

1031

Explain alternate key, candidate key and composite key in sql server?

895

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1045

Can you please differentiate between a primary key and a unique key?

993

What is 2nf normalization?

1002

How many primary keys are possible in a table?

911

How can windows applications connect to sql servers via odbc?

1109

What do you understand by mirroring?

986

What the different components of Replication and what is their use?

1054

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1062

What is view in sql?

884

Name and describe few console utilities for ssrs?

284

Explain contrast amongst grouped and non-bunched records?

1006