Why is this question about IIF broken because of the case sensitivity issue?

What real code would ever use varchar(1)?

Was the extra space in the varchar(4) field supposed to be...

Given that some of us might consider this a problem to be solved...

Can you index a computed column that is: left( [varcharmaxfield], 900 )

I understand there could be an...

We shouldn't use English as a reference for language implementation. Almost nothing is self-evident.

"Between Baltimore and Boston, which is your favorite city?"

- you have two enumerated options, select one...

This is another interesting language ambiguity.[1]

Of course it makes sense when you rewrite the between operator as: val >= p1 AND val <= p2

I would have expected "between" to have...

Good article.

The comments always find little details about your "generic" solution to make it a little more "generic" and flexible. 🙂

As far as sharing your use-case (telling a story) and...

Why should identity column promotion ever happen?

Ok, I understand that creating a table on-the-fly with an identity column might be pretty useful for further query against its clustered index, etc....

jay-h (5/10/2013)

---

Shoehorning is, unfortunately, not just inevitable, but necessary. Unlike the textbook computer science world where applications are planned, built, and used, and redesigned when new requirements arise, it is...

Are you implying that old code is inherently inferior...

Let me be the first to say... ^^ what he said. 🙂

Paul Randal (5/6/2013)

---

I hate to be negative, but it's extremely unfortunate that this script truncates the log, breaking the log backup chain, and that isn't explained anywhere in the script...

"a table which has one column with identity property"

I read the question incorrectly as "a table with one column additional to the identity column"

it's not an excuse; just a possible...

Please tell me you are using a local/desktop instance of SQL server to run this code and that you're not doing this on a production server.

I might try to convince...

Steve Jones - SSC Editor (5/1/2013)

---

Interesting thoughts, and we're definitely looking to add something here. We have been debating about some of the ratings of articles/scripts, but posts make sense...

L' Eomot Inversé (5/1/2013)

---

Sergiy (4/30/2013)

---

antony-688446 (4/30/2013)

---

Actually, this syntax is one of the worst and most dangerous things introduced by MS in SQL2008.

I saw extremely powerful servers brought down by improper...

Steve Jones - SSC Editor (4/29/2013)

---

What's the nod you want to give? I'm not completely sure what you're looking for here.

Is this a way to note how many shares of...