record-count

SQL Server Compact - count records/get space used for all tables in database

Is there a way to get a record count or a space-used value for all the tables in a SQL Server Compact database file (SQL CE 3.5.1)? ...

Get number of records scanned in aggregate query

My application performs a number of queries with the general form: SELECT <aggregate-functions> FROM <table-name> WHERE <where-clause> GROUP BY <group-by column list> I would like to know how many records contributed to the aggregate result set (in other words, how many records matched the conditions in the WHERE clause), something th...

Cascading counts for related groups: class, school, and district

I have a table like this: Student_id char(10 classroom_code char(5) school_code char(4) class_count int(4) school_count int(4) district_count int(5) It contains a school district's population of kids for a single grade level (3643 students). I want to do cascading counts for the class, ...

Row count and space usage in sql CE databases

Hi I have two DB1.sdf and DB2.sdf file (sql ce). I want to compare the two. I want to check the no of rows and the space used in each of the database. Is there any way to do that? Also is there any way to to a corresponding table to table comparision in the two databases? ...