Skip to primary content
Skip to secondary content

All Pinky, No Brain

…life tricks us with moments when everything seems to go right, but these soon pass…

All Pinky, No Brain

Main menu

  • Home
  • About

Monthly Archives: March 2009

have you seen this cat…?

Posted on March 13, 2009 by All Pinky, No Brain
Reply

have you seen this cat

Posted in Just Me | Tagged Interweb | Leave a reply

Copy existing SQL Table structure into a new empty table..? Easy…

Posted on March 6, 2009 by All Pinky, No Brain
Reply

Here’s the SQL Server thing: I want to copy an existing table’s structure, but not the data.

Here’s thefix:
SELECT * INTO MyNewTable
FROM ExistingTable
where 0=1

… which will do exactly that! Nice. Thanks to Josh for that.

Posted in Tech | Leave a reply

Recent Posts

  • When the Wires Sing
  • Alone
  • My Technophobe
  • A Name
  • Spleen

Categories

  • Flash Fiction
  • Just Me
  • Poetry
  • Tech

Recent Comments

I can see the flag on My Technophobe
Maud on Bitcoin – Revolution or E…
Dave on Creating FileZilla User via VB…
Mel A Rowe on God came over to my place
Rob on Creating FileZilla User via VB…
Follow All Pinky, No Brain on WordPress.com

Archives

  • November 2020
  • January 2018
  • December 2016
  • November 2015
  • June 2015
  • May 2015
  • December 2014
  • September 2014
  • April 2014
  • January 2014
  • August 2013
  • June 2013
  • May 2013
  • April 2013
  • January 2013
  • December 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • March 2012
  • January 2012
  • November 2011
  • October 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • August 2010
  • July 2010
  • June 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • July 2009
  • June 2009
  • May 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • All Pinky, No Brain
    • Join 28 other followers
    • Already have a WordPress.com account? Log in now.
    • All Pinky, No Brain
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar