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

What happens if null values are involved in boolean operations?

736


Explain the working of sql privileges?

797


What is the difference between SQL notification and SQL invalidation?

784


Explain features and concepts of analysis services?

673


What the class forname () does?

709






Explain what is public role in sql server?

786


How do you create a clustered index?

710


What is the purpose of optimization?

720


What is the current limitation of the size of SQL Azure DB?

120


What is a partition function in sql server?

699


How to find tables without indexes?

778


How do I shrink an ldf file?

731


Explain user defined functions?

789


can you instantiate a com object by using t-sql? : Sql server database administration

713


How to create an index on a view?

745