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

Explain what is cte (common table expression)?

1111

how can a database be repaired? : Sql server administration

955

Can a table have 2 primary keys?

967

How do we Backup SQL Azure Data?

108

Explain few examples of stored procedure over triggers?

1010

Difference between Logical Page and Physical Page in SSRS.

474

Can we use pragma autonomous_transaction in trigger?

938

What is tempdb in sql server?

947

Explain in brief how sql server enhances scalability of the database system?

963

What are the source of constraints?

897

Explain the use of containers in ssis and also their types?

953

Explain about thread and memory management process of SQL?

956

What is a dbms wizard?

999

Explain about integration services of Microsoft SQL server?

1016

Detail about the hardware which is supported by SQL server?

1045