.Net Database Interview Questions and Answers

 

Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?

SELECT count( * ) as totalrecords FROM employee




This will display total records under the name totalrecords in the table employee






use COUNT_BIG




Returns the number of items in a group.






@@ROWCOUNT




Returns the number of rows affected by the last statement.




Use this statement after an SQL select * statement, to retrieve the total number of rows in the table

Posted by:Richards