Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.

Answer:

a. select count (coumnName(s)) from tableName.
b. select count_big(coumnName(s)) from tableName
c. select columnName from tableName
select @@ROWCOUNT as rowCount

Asked In ::

Priyanka Singh
23 Feb, 2019 5:07 AM

a. select count (coumnName(s)) from tableName.
b. select count_big(coumnName(s)) from tableName
c. select columnName from tableName
select @@ROWCOUNT as rowCount

Reply

Rate This: +0 -0

Report