Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...

I mentioned that I spotted some regression in SQL Server 2008 SP1 regarding the ORDER BY within a VIEW. The history behind this is that the ORDER BY clause was allowed in SQL Server 2000 Views and ...