Congratulations to El Jerry and Lynn Pettis. 😀

I used my native language because "The Czech dialect is said to be of great antiquity and of highly scientific cultivation. Its alphabet...

Sean Lange (9/13/2012)

---

Good question.

For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of everybody on this...

arthurolcot (9/13/2012)

---

I got the answer right but got the intention of the question wrong.

When I thought, can I get that script to run without changing it, my method to achieve...

Raghavendra Mudugal (9/13/2012)

---

Hugo Kornelis (9/13/2012)

---

Finally, I can give you one example where this knowledge can be useful: when you have a co-worker whose idea of fun it is to change...

Hugo Kornelis (8/16/2012)

---

Hmmm, interesting. Good, solid evidence. However, when I add SET ANSI_NULLS OFF or SET ANSI_NULLS ON to...

Hugo Kornelis (8/16/2012)

---

honza.mf (8/15/2012)

---

+1

And even worse...

mtassin (8/15/2012)

---

At leats this thankfully won't be an issue sooner or later. SET ANSI NULLS OFF will throw...

+1

And even worse the answer is...

Hugo Kornelis (8/4/2012)

---

Am I overlooking something, or has nobody yet asked the really relevant question - why would anyone put comments in dynamic SQL? They should go in the non-dynamic...

L' Eomot Inversé (8/3/2012)

---

You could be right. I see a space there, but on more careful study of the image I'm far from sure. :ermm:

In fact (looking at...

Oh, the variables are too short.

I guess author wrote and tested the question and before submitting he inserted some spaces.

So my response was wrong but I have my point.

Omit the "(Choose 5)" advice and the number of correct answers fall down (including me) 😉

L' Eomot Inversé (7/18/2012)

---

Nice easy question.

But obviously batch 1 works, and batch 2 can't work (because the table is dropped by the exit from exec), and only one...

Mike Palecek (7/18/2012)

---

Very good question. I write code fairly often and it seems there is more to think about in SQL about scope than many programming languages. Either that or...

roryp 96873 (7/16/2012)

---

honza.mf (7/16/2012)

---

rhythmk (7/16/2012)

---

It is upto you if you want to learn you can use in such cases where it is hard to count the characters (exactly 30 in...