dot Net Database Question:
Name 3 ways you can get an accurate count of the number of records in a table Using query analyzer?
Answer:
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
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
| Previous Question | Next Question |
| Explain the different types of replication? How are they used? | Explain similarities and differences between the Java and .NET? |