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

Answer Posted / elumalai.k

select @@rowcount
select count(*) from tablename

Is This Answer Correct ?    5 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between a primary key and a unique key? : Sql server database administration

712


How to provide column names in insert statements in ms sql server?

807


What are the steps to process a single select statement?

686


Explain the use of keyword with encryption. Create a store procedure with encryption?

725


You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

134






Which table keeps the locking information?

695


What is query and its types?

684


What does the on update no action do?

759


Explain the microsoft sql server delete command? : SQL Server Architecture

776


Describe in brief authentication modes in sql server.

731


Do you know the cursor optimization tips?

744


Explain raiserror in sql server?

753


Can you tell me some of the common replication dmv's and their use? : sql server replication

710


What is an indexed view?

744


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

825