Back to the basics question - love it!

Python newbie here.  Why is the value of val1 (and val2) 30.0 and not just 30?

 

"What's a table valued constructor?" was definitely my "correct" answer today!  Learned something.

nenad-zivkovic (4/24/2013)

---

Thank you all for your comments. I am glad to hear you liked the question, as this is first time I am posting one. Idea for this came up...

The problem with the original explanation is this

---

COUNT(convert(int,NULL)) - It will give count as 0 always. Don't know why it is giving 0 count however COUNT() function counts NULL...

I thought the original poster's explanation was great: I found it very simple to understand and I liked the way each count statement was addressed individually.

sknox (3/18/2013)

---

I'm curious: What was the point of the cursor-like WHILE and incrementing the ID by 3? Just Obfuscation? Why didn't you just write the query as:

SELECT ID AS 'Select...

I guess I'm the only one that initially looked for '1/9' as an answer choice. Doh.

I nominate this question for Best Question of the Month! Well-written and has real world implications if not understood.

But, I will point out this is not just true for...

Hugo Kornelis (12/4/2012)

---

I picked the wrong option. If I had checked the submitter of the question, I probably would have picked the right option - I don't think I ever...

Stumbled across this Q&A thread using Google. Jeff's solution was ideal for my situation. Thank you!

Thank you, john.arnott, for your detailed explanation. No doubt there were many of us who benefitted!

sknox (9/27/2012)

---

1. Query 1 fails because there are no values provided to INSERT.

2. Query 2 fails because the syntax for SET IDENTITY_INSERT requires a table name.

3. Query 3 succeeds because...

joe.wolfe (9/13/2012)

---

The given answer to this question is "true", but I am not sure this is correct. The "NotGo" throws an error "Incorrect syntax near 'NotGo'" and the variable

Wow, have you considered vision corrective lenses?

(Forgive me, I can't...