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

What is the recursive stored procedure in sql server?

1015

Can a table have 2 primary keys?

977

What is cursors? And what are the different types of cursor?

1135

where the connection string store in the database

2061

Explain the usage of floor function in sql server.

954

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

265

What are the steps to follow to configure SQL*Net?

1025

How to add additional conditions in SQL?

1016

How to generate create procedure script on an existing stored procedure?

1001

How to access the deleted record of an event?

1028

How to generate create view script on an existing view?

978

What is apply operator in sql?

1006

Can binary strings be converted into numeric or float data types?

1021

What do you understand by sql server agent?

972

What is the difference between a stored procedure and a user defined function?

1014