SQL select into statement

code :: copy and swap database tables in MSSQL

have you ever had a database table that you needed to clone? you can use any number of convoluted methods such as: manually coping and pasting rows in the database manager, running lots of queries/stored procedures, or writing a script to cycle though each row copying data from one table to the next. all of these methods are inferior and far more complex then the method i'm going to show you.

introducing the select into query...
this method should be used if the table you want to clone exists, but the new table douse not. the select into query will create the new table for you, copying all the column names, properties, and data. if you want to make an exact clone of the table you can select * into the new table. but if you only want a few specific columns, you can declare only the ones you want. the syntax is elegantly simple...

SELECT *
INTO [new-table]
FROM [old-table]

Read: SQL select into statement »

R4-DS

entertainment :: the nintendo DS homebrew revolution

R4-DS the homebrew revolution

the nintendo ds is an awesome portable gaming system. i have the ds lite, its thin, weights under a pound, has two super bright backlit screens, pretty sweet integrated speakers, the classic nintendo plus d-pad, four front buttons, and two shoulder buttons. the bottom screen is touch sensitive, which makes for some awesome gameplay. the touch screen is sick, but a lot of people can be put off by it. so tons of games let your switch between the touch motion and d-pad motion.

the nintendo DS

Read: R4-DS »

chiptune albums to rock out

entertainment :: releases by phlogiston, nonfinite, and starscream

phlogiston - nectar

nectar by phlogiston - nectar is 2 EPs in one. part one, Croquel Adventure, continues in the chip-tune tradition of short, fun, pure NES songs. while part two, HEAT, transports you to an 80's vision of the distant future. the album is a tour through a vast dystopian cityscape where high-tech low-life roam the streets. and the lines between man and machine have been washed out.

 
 

Read: chiptune albums to rock out »

vegan chocolate chip cookies

notes :: my delicious recipe

vegan chocolate chip cookie recipe

start with a small container of margarine
(like 7.5oz of promise or smart balance)

blend in some sugar.
i use about 1/3 brown sugar, 1/3 white sugar, and 1/2 a cup of confection [powdered] sugar.

*optional*
you can also use 1 table spoon of honey and/or agave nectar.

stir until creamy.

add 1 tea spoon vanilla and stir.
add flour.
(i like to mix 1/2 cup of whole wheat flour and 1+1/2 cup of white flour.)

*NOTE*
if you used honey / agave nectar you'll need and extra 1/2 cup of flour.

add 1 tea spoon of salt.
add 1 tea spoon of baking soda.
add 1 tea spoon of baking powder.

you want the dough to be stiff not sticky. if necessary, add more flour...

Read: vegan chocolate chip cookies »

two free video game fonts!

art :: metroid and ghosts n' goblins

metroid font - NARPASSWORD00000 - fontvir.us

i have been wanting to make a metroid font for a long time now.NARPASSWORD00000 is made from the classic nintendo NES game metroid's password screen. the font also includes some dingbatz made from the games sprites. but i decided to go the extra mile and create the rest of the full international character set. the fonts name is a reference to a special backdoor password hidden in the game. click here to download.

Read: two free video game fonts! »

TK and the penguins

random :: pittsburgh penguins hockey practice

pittsburgh penguins #48 tyler kennedy and xero

so the other day nina, will, and i went to a pittsburgh penguins hockey practice. i got to meet TK! (aka #48 tyler kennedy) i couldn’t believe that he was only a little bit taller than me, but he's carved out of solid rock! GO PENS! this is the last season for mellon arena so it was nice to get to visit the igloo one last time. 

Read: TK and the penguins »

gameboy prosound mod

lab :: console modification for better sound recording

nintendo gameboy prosound mod

today’s mod is for the original nintendo gameboy. if you want to get serious about chip tunes, whether your using lsdj or nanoloop, the sound quality of your instrument is a priority. the stock nintendo gameboy is equipped with a single headphone jack. and if you have ever tried recording anything from that, it sounds pretty bad. thus the prosound modification was invented to add a line out jack to the gameboy.

Read: gameboy prosound mod »