May 11 2010, 06:23 PM
QUOTE(u007 @ Apr 22 2010, 10:07 PM)
Which of the following SQL contains error?
2 Options make me wonder (forgot the name and value):
- select field1 from emp where field1='xxx';
- select field1 from emp where field2=`xxxx';
p/s: and then i'm wondering, it wouldnt make sense to select the field with that value if you already know the value,
unless you want to check if the value exists, but then 2nd answer make me worry
if the person who typed this document forgotten that m$ word actually converted all starting ' to `
Which 1 have error? im kind of speechless here
I'm not a programmer but seem the 2nd option is wrong... why should I care about m$ conversion in test? If you really care, you should ask them before you hand in your lovely answer :-)2 Options make me wonder (forgot the name and value):
- select field1 from emp where field1='xxx';
- select field1 from emp where field2=`xxxx';
p/s: and then i'm wondering, it wouldnt make sense to select the field with that value if you already know the value,
unless you want to check if the value exists, but then 2nd answer make me worry
if the person who typed this document forgotten that m$ word actually converted all starting ' to `
Which 1 have error? im kind of speechless here
I would love to try to apply with this company too... but I do not think they have sys admin post (might be i check at the wrong time)...
Quote
0.0153sec
0.44
6 queries
GZIP Disabled