select @@rowcount select count(*) from tablename

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

Question Posted / elumalai.k

Answer Posted / elumalai.k

select @@rowcount
select count(*) from tablename

Is This Answer Correct ?

5 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Which are new data types introduced in sql server 2008?

988

What is the use of toad or sqldbx.?

1098

Can foreign key be duplicate?

999

What are the types of database schema? : sql server analysis services, ssas

1068

Explain about unique identifier data type in sql server?

857

How many cores do I need for sql server 2016?

848

how many layers of tcp/ip protocol combined of? : Sql server database administration

937

What are sub reports?

186

What is report snapshot in ssrs?

247

What is the difference between substr and charindex in the sql server?

1001

How to sort the query output with order by clauses in ms sql server?

983

What is indexed view?

927

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

911

Does partitioning improve performance sql server?

897

What is the default sql server instance name?

970