Re: Count Table rows using Stored Procedure

[A. Aquiles]

Thanks for the quick reply Peter.

Two issues:

1) table_schema is with an underscore (I noticed but some people may not).

2) More importantly, the information-schema gives *approximate* figures (e.g. in my case a table with exactly 83,290 appeared as having 83,727 rows).

That was the reason to use count(*) inside an stored procedure.

Re the printing, yes, creating a variable @totalcount and then "select @totalcount" shows the result on screen fine.