Granted, the article is for SQL Server 2000, but one would hope the scope doesn’t change between versions. According to the article How triggers affect ROWCOUNT and IDENTITY in SQL Server 2000, @@ROWCOUNT will not be affected by triggers. Specifically: It’s safe to use @@ROWCOUNT in SQL Server 2000 even when there is a trigger … Read more
Statement.executeUpdate() or execute() followed by getUpdateCount() will return the number of rows matched, not updated, according to the JDBC spec. If you want the updated count, you can specify useAffectedRows=true as a non-standard URL option. More information is available here.
You could specify an OUTPUT clause on your MERGE statement and get an output report of what’s been done during MERGE. MERGE (targetTable) AS t USING (sourceTable) AS s ON t.ID = s.ID WHEN MATCHED THEN (some statements) WHEN NOT MATCHED THEN (some statements) OUTPUT $action, inserted.ID ‘inserted’, deleted.ID ‘deleted’ ; This will give you … Read more
In the latest version of jqGrid, you can set rowNum to -1 to instruct the grid to always display all rows: rowNum: -1 See the latest jqGrid documentation here. Specifically: Sets how many records we want to view in the grid. This parameter is passed to the url for use by the server routine retrieving … Read more
If you are working on a large data set and are okay with a pretty good approximation, I highly recommend using the command: nodetool –host <hostname> cfstats This will dump out a list for each column family looking like this: Column Family: widgets SSTable count: 11 Space used (live): 4295810363 Space used (total): 4295810363 Number … Read more
You can use RETURNING clause: DELETE FROM table WHERE condition IS TRUE RETURNING *; After that you just have to check number of rows returned. You can streamline it with CTE: WITH deleted AS (DELETE FROM table WHERE condition IS TRUE RETURNING *) SELECT count(*) FROM deleted; This should return just the number of deleted … Read more
Counting rows in big tables is known to be slow in PostgreSQL. The MVCC model requires a full count of live rows for a precise number. There are workarounds to speed this up dramatically if the count does not have to be exact like it seems to be in your case. (Remember that even an … Read more
The following SQL will get you the row count of all tables in a database: CREATE TABLE #counts ( table_name varchar(255), row_count int ) EXEC sp_MSForEachTable @command1=’INSERT #counts (table_name, row_count) SELECT ”?”, COUNT(*) FROM ?’ SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC DROP TABLE #counts The output will be a list of … Read more
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘{your_db}’; Note from the docs though: For InnoDB tables, the row count is only a rough estimate used in SQL optimization. You’ll need to use COUNT(*) for exact counts (which is more expensive).