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

How to modify an existing stored procedure in ms sql server?

541


What are the different types of locks in the database?

488


Explain the stored procedure?

645


Explain what are the restrictions while creating batches in sql server?

595


How is sql used in sql server?

507






Explain intellisense for query editing

571


What are translations and its use? : sql server analysis services, ssas

611


What are cursors stored procedures and triggers?

525


What is mean by candidate key?

554


What action plan is preferred if sql server is not responding?

539


Why would you use sql agent?

738


Does group by or order by come first?

546


What does it mean to manipulate data?

570


How to use values from other tables in update statements in ms sql server?

561


What are the differences between stored procedure and the dynamic sql?

587