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 is conditional split?

633


Explain differentiate between a having clause and a where clause?

590


What is logshipping and its purpose?

635


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

114


How do you make a trace?

669






List the different normalization forms?

622


What is scrollable cursor?

646


What is the name of the Database which IBM mainframe uses?

639


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

580


What is difference between cte and view?

605


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2264


What is a group function explain with an example?

620


Explain different types of index?

685


Why use cursor in sql server?

641


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

807