The Tomes of Experience

'Cause there are some things you just *can't* get from a book…

Recent Posts

  • Resizing Raspbian image for QEmu
  • git-describe and the tale of the wrong commits
  • Scripting Google Chrome for OSX using AppleScript
  • BASH – [: too many arguments
  • Setting up Time Machine on a LaCie Network Space, wireless-ly

Recent Comments

  • Raj on This action is invalid when the mock object is in verified state
  • Tom on This action is invalid when the mock object is in verified state
  • alex on git-describe and the tale of the wrong commits
  • Jan Warchoł on git-describe and the tale of the wrong commits
  • Silas Lima on Resizing Raspbian image for QEmu

Archives

  • June 2013
  • December 2010
  • September 2010
  • August 2010
  • July 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • November 2007
  • October 2007
  • August 2007
  • May 2007
  • April 2007
  • April 2006
  • March 2006
  • February 2006
  • July 2005
  • June 2005

Categories

  • IT & Software

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Month: October 2007

sp_MSforeachtable sproc

October 30, 2007 by Xerxes·0 Comments

sp_MSforeachtable sproc

LINK: http://weblogs.sqlteam.com/joew/archive/2007/10/23/60383.aspx

Why write a cursor to traverse each table – this stored proc allows you to traverse each table automatically:

EXECUTE sp_MSforeachtable ‘EXECUTE sp_spaceused [?];’;

Neat!

——————

Proudly powered by WordPress. Theme: Flat 1.7.2 by Themeisle.
Close Bitnami banner
Bitnami