Mike Dougherty-384281 (5/13/2013)

---

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...

marlon.seton (5/13/2013)

---

Whilst I agree, I wonder if anyone has ever used this idea in a real piece of coding? The values are hard-coded and...

Try using c.max_length instead of t.max_length.

The column t.max_length is the maximum for the type (varchar); c.max_length is the maximum for this specific column.

Unfortunately, I can't. This is not consistent at all. In many other cases,...

paul.knibbs (5/9/2013)

---

Thanks...

nenad-zivkovic (5/9/2013)

---

Since nothing from subquery's table is actually selected here - it can very well be omitted. Any of these would be exactly the same:

select * from address_oltp where...

paul.knibbs (5/9/2013)

---

Have to admit, I'm puzzled by this behaviour. It doesn't make logical sense for SQL to make a substitution like this when the table you're selecting from is explicitly...

Client_id vs Clientid - I am glad I noticed this in the last minute.

The question pretends to be about subqueries, but I am pretty sure that the 38% people that...

Mighty (5/8/2013)

---

It also might be because it is still early here, but what is the point exactly?

. What is it exactly why it works? The...

Not if you execute the entire code block as a single batch (as instructed in the question). The error in statement #6...

Thanks! Good question.

In addition to the explanation given: the restriction actually makes sense. Remember that, logically, the ORDER BY is performed *after* the SELECT. In the official ANSI standard, columns...

SQLRNNR (5/6/2013)

---

On the topic of people offering thanks for the question etc etc etc. Since I like to do it, I will confess to the reason behind it. ...

wolfkillj (5/6/2013)

---

Good question - I appreciate the QotDs that demonstrate quirky behavior.

It bears mention that Microsoft has slated the "timestamp" syntax for deprecation in favor of "rowversion" as of...

If that is the case,...

demonfox (5/6/2013)

---

I don't see any problem in banal comments , such as "Thanks for the question" , "nice question" ; I think it encourages the author; whereas my post was...