Skip to content
Laxmi Lal Menaria Blog!

Laxmi Lal Menaria Blog!

My Journey from Developer to …….?

  • Home
  • About Me
  • Amazon Top Deals

Tag: Temp Table

Posted on March 18, 2018May 17, 2018

Get rows count of the tables – Microsoft SQL Server

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

Recent Posts

  • How to list SQL Jobs using Query?
  • How to update the Max Memory at SQL Server?
  • How to use CLR function at SQL Server?
  • How to enable “Windows Authentication” for your websites?
  • RDP- Automatically sign out of disconnected users?

Amazon Deals


Archives

  • July 2022
  • June 2022
  • March 2022
  • February 2022
  • January 2022
  • November 2021
  • August 2021
  • June 2021
  • March 2021
  • May 2020
  • December 2019
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • February 2019
  • December 2018
  • September 2018
  • June 2018
  • May 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • May 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2016
  • May 2016
  • April 2016
  • January 2016
  • December 2015
  • January 2015
  • August 2014
  • June 2014
  • May 2014
  • January 2014
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • March 2013
  • February 2013
  • December 2012
  • August 2012
  • June 2012
  • May 2012

Categories

  • Addins
  • Apache Drill
  • Archiving
  • ASP.Net MVC
  • Browser
  • C#
  • CLR
  • CSV
  • CYGWIN
  • Database
  • Duplicate
  • Editor
  • Emails
  • Encryption
  • Enter key
  • errors
  • excel\
  • Excelption
  • General
  • IIS
  • Java
  • Javascript
  • JQuery
  • Koha
  • Macro
  • MSSQL
  • MYSQL
  • Online
  • Oracle
  • Outlook
  • Performance
  • permission issue
  • Remote
  • Rewrite
  • Security
  • Sharing
  • Uncategorized
  • USB
  • VNC
  • VS2013
  • VS2015
  • ware
  • Windows Application

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Home
  • About Me
  • Amazon Top Deals
Proudly powered by WordPress