Excellent question, thanks

Good question! Good to be reminded of this about constraints on temporary tables.

I think the following article explains it:

http://msdn.microsoft.com/en-us/library/ms188783.aspx

in the "DROP_EXISTING Clause" section.

Hi,

You might check pivot: Using PIVOT and UNPIVOT

GilaMonster (2/7/2012)

---

Without an order by the results are returned in whatever order the last query operator left them in. If all the query did was a scan of an index...

Thanks for the question, i will try to remember ... 🙂

I wouldn't mind :). Still, an msdn reference, if there is any relevant,...

Nice and important question. This issue is coming up time to time when discussing differences of delete and truncate operation.

L' Eomot Inversé (2/1/2012)

---

I'd prefer to have a configuration option that determines whether it's a warning message...

GilaMonster (2/1/2012)

---

Question is, how far do you go?

Just char, varchar, nchar, nvarchar, binary, varbinary?

Also decimal and numeric (default is numeric(18,0))?

Also time (default is time(7)), datetime2 (default is datetime2(7)) and datetimeoffset...

I lay my vote for that declaration of varchar/char/nvarchar/nchar/binary/varbinary/etc data types without specifying length should throw an error (or at least warning) by the parser. Anyone, lead me and I...

Nakul Vachhrajani (2/1/2012)

---

I like it too!...

Hm, after some thinking i got it right :), although it is a kind of trick question as, to my knowledge, you cannot directly reference columns in another table, only...

I don't understand what this /text() optimization does. On my system it makes the...

Very useful question, thanks. I learnt something about xml parsing and also optimization so far today :). Thanks for all the comments.

I would also like to defend the question. I...