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

Do you know the cursor types?

1205

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1174

How many columns can we include on clustered index ?

1060

Explain different backup plans?

1007

What is the difference in accessing db between sql server vs sql azure?

174

What security features are available for stored procedure?

1080

What is catalog views?

1122

What's the information that can be stored inside a bit column?

1072

What is rtm version in sql server?

1106

What do you mean by table and field in sql?

1066

What is 2nf example?

1055

What is lock escalation and what is its purpose?

1029

Explain the cursor lock types?

1100

What new changes are being made in SQL Server?

1272

List the types of recovery model available in sql server?

972