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