hfrmobile
Member since Apr 2, 2009
- Profile: /members/3213-hfrmobile.htm
- URL: http://www.hfrmobile.com
- Comments: 2
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 for another but similar sample. I need to purge ... read more »