sknox (6/3/2013)

---

Good question! I would clarify the answer a little bit, though:

should probably be

...

True, but only in this case....

I don't get it.

First, the idea of the question. We are given SQL to create and populate a table, *and* SQL that (supposedly?) shows the correct answers. Are we supposed...

You can't create red color in an empty message pane. But if you first execute a statement that will generate an error, then type...

I didn't test it,...

I am not surprised that SELECT ... INTO loses the FILESTREAM attribute. However, I was surprised to find that varchar(max) with FILESTREAM would be converted to varbinary(max).

So then I did...

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

---

There is indeed a rule that no column with type nvarchar(max), varchar(max) or varbinary(max) can be used in index keys. However, it isn't documented on that...

Toreador (5/28/2013)

---

But don't quite understand the statement "The key to this is of course the use of DISTINCT".

There is no use of DISTINCT, so how can it be the key...

A normal (permanent) table. It...

Mighty (5/27/2013)

---

Nice start of the week.

One remark though:

This not only works when an error has been generated. Any message that...

Dineshbabu (5/23/2013)

---

Still now I was trying as you mentioned in the bonus point (table creation + insert statements) at once. So while parsing time both tables was not exist but...

Sure. It's here: http://www.sqlservercentral.com/questions/T-SQL/98942/%5B/url%5D.

First run the part...

David Conn (5/23/2013)

---

It's a shame that "Between -1 And -10" and "Between -10 and -1" aren't equivalent in T-SQL.

I haven't read BOL re. "Between" but does it state that it...

Dineshbabu (5/23/2013)

---

Hugo,

In this scenario, eventhough if we run both insert statements as single batch, first statement will be executed successfully and we will get error only on second one...

I'm little bit confused with your explaination,

I didn't understand this part. can you give some...