Number of different ways to get total number of rows from tables

Herman<T>.Instance

3 Jun 2011CPOL

2.5K

SELECT LEFT(OBJECT_NAME(id), 30) AS [Table],CAST(CAST(cast(reserved as bigint) * 8192 AS bigint) / 1000000.0 AS DECIMAL(15,1)) AS 'Allocated (in M)',CAST(CAST(cast(dpages as bigint) * 8192 AS bigint) / 1000000.0 AS DECIMAL(15,1)) AS 'Used (in M)',CAST(CAST(cast((cast(reserved as bigint) -...

Only logged in members can view this content

Please go to the ASP.NET Table of Contents to view the list of available articles in this section.

Closed because content has been posted that is spam. Reported by Afeefajmal on Friday, December 2, 2011 3:07pm