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: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.
June 14, 2015 at 8:48 am
roopa.subbareddy (6/14/2015)
There is no Single quotes in the Select for the phone number. So it must give an error message.
Try running the code. You'll see that the integer values are silently converted to character without raising an error.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply