Hall of Fame
June 11, 2015 at 10:51 pm
Comments posted to this topic are about the item What will happen with below code???
Thanks,Shiva NDatabase Consultant
June 12, 2015 at 12:10 am
Looks easy, but I did expected an error on missing the single quotes, not because of the UNION.
But after execution I noticed that 1 row was inserted.
And yes, the int with or without quotes, both works.
June 12, 2015 at 2:03 am
Looks easy, but need to notice the Union rather than Union ALL!!! Really need to read the question carefully...
June 12, 2015 at 2:23 am
Missed the missing ALL. Where is my coffee again?? 😀
June 12, 2015 at 4:51 am
The question had several things to look at and consider. Nice.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions
June 12, 2015 at 6:25 am
This was removed by the editor as SPAM
June 12, 2015 at 6:39 am
Michael Riemer (6/12/2015)Looks easy, but need to notice the Union rather than Union ALL!!! Really need to read the question carefully...
Michael Riemer (6/12/2015)
+1 Thanks for the great question. I noticed it was missing an ALL at the last minute and changed my answer.
June 12, 2015 at 6:50 am
Easy but encourages a bad practice: Using an INSERT statement without a column list. OTOH if you had a column list with the two non-identity columns, the question would have been too easy.
Gerald Britton, Pluralsight courses
June 12, 2015 at 11:06 am
g.britton (6/12/2015)Easy but encourages a bad practice: Using an INSERT statement without a column list. OTOH if you had a column list with the two non-identity columns, the question would have been too easy.
June 12, 2015 at 11:34 am
Easy one for a Friday. Thanks!
June 12, 2015 at 1:08 pm
Friday Fun. Scored 1 mark.
June 12, 2015 at 1:20 pm
Nice and simple - thanks, Shiva!
June 12, 2015 at 1:57 pm
Yep. Got burned by the lack of 'ALL'. That will teach me to read a little more carefully.
June 14, 2015 at 5:50 am
Nice tricky question, thanx.
June 14, 2015 at 8:39 am
There is no Single quotes in the Select for the phone number. So it must give an error message.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply