SET NOCOUNT ON IF IsNull(object_id('tempdb..#temTable'),0)<>0 DROP TABLE #temTable CREATE TABLE #temTable ( Name sysname, Rows INT, Reserved sysname, Data sysname, IndexSize sysname, UnUsed sysName ) INSERT INTO #temTable EXEC sp_msForEachtable " sp_SpaceUsed '?' " SELECT Name, Rows FROM #temTable ORDER BY Name IF IsNull(object_id('tempdb..#temTable'),0)<>0 DROP TABLE #temTable
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
Wednesday, April 02, 2008
Microsoft SQL Get Number of Rows from All Tables
Below is a quick and easy method to retrieve number of rows / records from all tables in a database. The below code snippet is tested on Microsoft SQL Server 2005.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
-
The Google Adsense made a blog post with a video to help us understand the concept behind eCPM (Effective Cost Per Thousand Impressions). ...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
An efficient method to find out the total record counts of all tables in an Oracle database. select table_name, to_number(extractvalue(xm...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.