June 11, 2015 at 10:51 pm
Comments posted to this topic are about the item What will happen with below code???
Thanks,
Shiva N
Database 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.
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...
+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.
+1
Don Simpson
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.
Thanks.
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.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
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 18 total)
You must be logged in to reply to this topic. Login to reply