Need a row count after SELECT statement: what’s the optimal SQL approach?
If you’re using SQL Server, after your query you can select the @@RowCount function (or if your result set might have more than 2 billion rows use the RowCount_Big() function). This will return the number of rows selected by the previous statement or number of rows affected by an insert/update/delete statement. SELECT my_table.my_col FROM my_table … Read more