RBarryYoung (3/4/2010)

---

Tom.Thomson (3/4/2010)

---

(2) SQL includes numerous statements whose sole function is to have side effects - not to describe the result of the total computation. So it is not...

RBarryYoung (3/4/2010)

---

Tom.Thomson (3/4/2010)

---

edit to fix spelling (English spelling is awful/impossible:(, whether US version or UK version; maybe I should add something like "Tha mi sgith de litreachadh na Beurla" to...

It's a good question in that it's spurred an interesting discussion.

I think a lot of people arguing about what SQL should do about truncations like this are starting from the...

SQL is actually a procedural language, and not a declarative language. At least two reasons:...

Adi Cohn-120898 (3/3/2010)

---

If I'll modify the question and ask to select all possible answers, you'll agree with me that more then one of the possible answers that we were given...

What a terrible question! We don't know whether there are any rows in tblUsers, so we don't know whether any rows will be returned or not. If there are any...

Yes, "order by (select 0)" is a nice. It's...

David,

I think that before dealing with your reply I should quote from the eminent authority to whom you appeal just to dismiss the idea that I am disagreeing with...

Good question.

I don't know whether to be more worried that 198 people so far thought datalength behaved like length or that 118 thought 11 was an even number!

Nice question but one niggle about the explanation: if the procedure option RECOMPILE is specified the same plan will NOT be used in subsequent executions. This can be useful...

I think a lot of the earlier comments have been oversimplistic - it's not just a matter of saying "UTC is best, stick time localisation in the presentation or application...

People have talked about deletes and avoiding deleting things that are used once a year. Something else not to delete is error recovery and disaster recovery code - this...

This...

Lynn Pettis (1/31/2010)

---

Still don't see SQL, or its variants (T-SQL, PL-SQL, etc), going away any time soon. Just like COBOL, I see it having a long life, or at...

David Portas (11/17/2009)

---

Elliott W (11/17/2009)

---

Oh dear! I wasn't...