(long) ladyfinger

Actually I chose NO because I knew that for a small enough table and/or the right lack of selectivity of the where predicate for...

Or watching grass grow.

Thomas Abraham (2/17/2012)

---

We're big on "Quality Initiatives" where I work, and our biggest customer is always...

SQL Kiwi (2/16/2012)

---

It is certainly very good practice to match data types, but that is not the only way to obtain a seek here (assuming the default collation is a...

GSquared (2/16/2012)

---

I may be missing something. Do the comments...

That's a new word on me. Could mean something like "zany ointment", I suppose. 😉

But as far as I can tell it...

chlorphen(ir)amine maleate

Another nice straightforward one with no twists/tricks/typos. Thanks.

Hugo Kornelis (2/15/2012)

---

Sean Lange (2/15/2012)

---

I still don't quite get the point to be honest. It is kind of like saying "you can insert data into this table but this trigger...

Good question (I was lucky and didn't see it until after the errors were fixed ;-).

I didn't know the answer (I'm very familiar with instead of triggers but I'm...

youch indeed!

I like the first (David Benoit) response.

Piper

Nice question, but the answer is a complete fail :angry:.

The whole batch will in fact fail because a variable can only be declared once ion a batch, so...

Thanks Paul....