Query Size needed

[wysota]

It's about asking the database to return the number of rows in the table.

[baray98]

I don't think this is an easy task since my user will input the SQL statement and then i will display the result in a table. and the number of records return would be at the bottom

Is there any other way of knowing the sqlresult size?

Is there anything i should in MS SQL to support sqlresult size?

baray98

[Lykurg]

parse the string with the query and replace the content between SELECT and FROM with count(1), then you will get the number of rows for that particular query.