Subqueries in CASE Expressionshttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspxIn this post, I’m going to take a look at how SQL Server handles subqueries in CASE expressions. I’ll also introduce some more exotic join functionality in the process. Scalar expressions For simple CASE expressions with no subqueries, we can justen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)Maintaining Unique Indexes with IGNORE_DUP_KEYhttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspx#7334844Thu, 31 Jan 2008 01:01:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:7334844Noticias externas<p>A few months ago, I wrote a post describing how SQL Server maintains unique indexes while avoiding false</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=7334844" width="1" height="1">Maintaining Unique Indexes with IGNORE_DUP_KEYhttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspx#7334323Thu, 31 Jan 2008 00:18:08 GMT91d46819-8472-40ad-a661-2c78acb4018c:7334323Craig Freedman's SQL Server Blog<p>A few months ago, I wrote a post describing how SQL Server maintains unique indexes while avoiding false</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=7334323" width="1" height="1">Database Programming: Everything You Always Wanted To Know About JOIN Semantics, But Were Afraid To Askhttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspx#751358Wed, 13 Sep 2006 03:25:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:751358Ward Pond's SQL Server blogEvery once in awhile, I get an opportunity to look around for new and interesting things to read.&amp;amp;nbsp;...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=751358" width="1" height="1">Database Programming: Everything You Always Wanted To Know About JOIN Semantics, But Were Afraid To Askhttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspx#751288Wed, 13 Sep 2006 02:35:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:751288Ward Pond's SQL Server blogEvery once in awhile, I get an opportunity to look around for new and interesting things to read.&amp;amp;nbsp;...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=751288" width="1" height="1">Subqueries: ANDs and ORshttp://blogs.msdn.com/b/craigfr/archive/2006/08/23/715306.aspx#732411Thu, 31 Aug 2006 00:23:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:732411Craig Freedman's WebLogIn my “Introduction to Joins” post, I gave an example of how we can use a semi-join to evaluate an EXISTS...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=732411" width="1" height="1">