Community Member Profile

Recent Blog Comments By hfrmobile

• Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

  Posted on May 25, 2009 at 8:43 AM

  @BabyMilo: In that case you'll use an UPDATE command ... (of course you have to "calculate" the new values before using string functions)... read more »

• Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

  Posted on Apr 2, 2009 at 7:39 AM

  A strange sample ... Since there aren't foreign key constraints the bug in the sample wasn't seen by nobody ... ;-) "Arnold" (2) and "Vincent" (3) where deleted but in the relation table still contains an entry with boy_id = 2 ... I was looking... read more »