How do I count the number of Records in a Table?

If you need to count the number of records in a table, use the following query:

SELECT COUNT ( * ) AS RecordCounter
FROM TableName
Replace TableName with the name of your Table.
This will return one column named RecordCounter with the total number of records for the Table.