Question: what is the difference between count() and rowcount()?
Answer: Difference between @@RowCount and Count(*) @@Rowcount gives you the value of number of records affected by last executed query. Hi, ... So, @@RowCount is used to check number of rows affected only after a query execution. But Count(*) is a function, which will return number of rows fetched from the SELECT Query only.