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

Answer Posted / hokar

select count(*) from tablename.

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to encrypt Strored Procedure in SQL SERVER?

559


What kind of problems occurs if we do not implement proper locking strategy?

969


Do you know how to store and query spatial data?

609


What are data driven subscriptions?

79


Can we use custom code in ssrs?

591






What is the process of indexing?

522


What is the difference between seek predicate and predicate?

590


List out the differences between global and local temp tables in sql server?

578


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

589


Can you use order by when defining a view?

575


What command must you use to include the not null constraint after a table has already been created?

546


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1989


Explain DBCC?

572


Explain throw statement in sql server 2008?

583


What are security principals used in sql server 2005?

517