This is definitively a must-know. Spread the word :D...

I didn't understand the tips. Could you explain a bit more pls? If it's just that knowing you have a "identity" named column, you can use $IDENTIY instead of [identity] then this is useless....

The newly created objects list is discarded imediatly. The update is the part in parenthesis (I'm used to write "cascading" assignations)....

Note that the properties' names of the resulting instances of that Anonymous class can be anything (e.g. I could have use X, Y, Z)....

Actually, I was wrong. SQL Server just ignore ORDER BY clause when there's only one row to deal with. This: select * from ( select 1 as a, 2 as b union all select 2, 3 ) as x order by @@SERVERNAME + 345*'test' Will fail....

I guess SQL Server consider it a constant before evaluating it. And there's no need to know a constant result for a ordering clause....

I don't get why that makes it dangerous, Nakul. Plus, this behavior is to be expected....

Soundex is based on english phonems, it might not be efficient for other languages....

This make me think of SET IDENTITY_INSERT (http://msdn.microsoft.com/fr-fr/library/ms188059.aspx)....

Everywhere you could use a procedure though it's only relevant when you work with set of data. Here's a recent use look-alike I made of this (ASP.Net). I have a list of people with several checkboxes related of each one of them. Depending on the...