delete [TargetTable]
from [TargetTable]
join [JoinTable] on [TargetTable].[Column] = [JoinTable].[Column]
Friday, May 30, 2008
[sql] Delete rows with join to another table in SQL Server
The non-obvious part is that you have to put the table name twice -- after the "delete" AND after the "from".
Monday, May 26, 2008
[outing] Memorial Day
Sunday 2008 May 26 @ Casa de Lang
- Me to Pierre: "I bet you there is a California City"
- Pierre to Steve: "I lost the bet and you have to get in the boat with me" (or was it under the bus?)
- Killer asian-styled pulled pork by Maureen
- Loving that Maureen took the recipe and crossed out half the instruction. I am not the only one!
- Shrimp, scallops, sesame noodles, gyoza, chicken wings
- Sangria, Veev, Tunnel 88, Patron, Bicardi, Grey Goose, JD
- What can you do with fun-sized kit kats, plastic cups, coffee straws, plastic utensils, and permanent markers? You can decorate pierre
- Mike's secret Yoga skills
- Who knocked over the telescope?
- Me to Pierre: "I bet you there is a California City"
- Pierre to Steve: "I lost the bet and you have to get in the boat with me" (or was it under the bus?)
- Killer asian-styled pulled pork by Maureen
- Loving that Maureen took the recipe and crossed out half the instruction. I am not the only one!
- Shrimp, scallops, sesame noodles, gyoza, chicken wings
- Sangria, Veev, Tunnel 88, Patron, Bicardi, Grey Goose, JD
- What can you do with fun-sized kit kats, plastic cups, coffee straws, plastic utensils, and permanent markers? You can decorate pierre
- Mike's secret Yoga skills
- Who knocked over the telescope?
[quote] John Wooden on Team Work
"A player who makes a team great is much more valuable than a great player."
- UCLA Coach John Wooden
It's a wonderful quote on team work, but I'd like to offer a small edit. No where near as clever as the coach, but guaranteed to be true.
"A great player who makes a team great is much more valuable than a great player."
Saturday, May 10, 2008
[tools] Local IIS Webserver in 3 min
For some reason I was under the impression that running IIS on my local machine was gonna be a giant $ license + install ordeal. Thanks to Scott, who happened to inquire why I'm working at the office on a Saturday, to which I explained I couldn't stand the file save lags on to the dev server over VPN, who then pointed me to get IIS running on my machine.
Took all about 3 min.
Add IIS Component:
> Go to Start ... Settings ... Control Panel
> Click on "Add or Remove Programs"
> Click on "Add/Remove Windows Components"
> Check "Internet Information Services (IIS)" --- Just 13.5 MB!
> Click [Next]
> Watch the "progress bar dance" --- Less then 3 min.
> Close everything
Enable directory browsing:
> Go to Start ... Programs ... Administrative Tools ... Internet Information Services
> Click on + sign to until "Default Web Site"
> Right click on "Default Web Site". Click "Property"
> Under "Home Directory" tab, check "directory browsing", and change file root to whatever you want. Default is "c:\inetpub\wwwroot"
> Enjoy http://localhost
That sure all seems pretty darn obvious after the fact!
Now I can go home.
Took all about 3 min.
Add IIS Component:
> Go to Start ... Settings ... Control Panel
> Click on "Add or Remove Programs"
> Click on "Add/Remove Windows Components"
> Check "Internet Information Services (IIS)" --- Just 13.5 MB!
> Click [Next]
> Watch the "progress bar dance" --- Less then 3 min.
> Close everything
Enable directory browsing:
> Go to Start ... Programs ... Administrative Tools ... Internet Information Services
> Click on + sign to until "Default Web Site"
> Right click on "Default Web Site". Click "Property"
> Under "Home Directory" tab, check "directory browsing", and change file root to whatever you want. Default is "c:\inetpub\wwwroot"
> Enjoy http://localhost
That sure all seems pretty darn obvious after the fact!
Now I can go home.
Subscribe to:
Posts (Atom)