Ars Technica

SQL: an ORDER BY clause that will filter out "a" "an" and "the"

So I wanna sort something like "The Who" or "The Grateful Dead" by 'W' and 'G', respecively. How does one accomplish this? I tried using a function in the ORDER BY clause, but SQL syntax doesnt seem ...
Ars Technica

Dynamic SQL 'ORDER BY' clause

I want to set up a stored procedure where the data is ordered by column according to user input, i.e.<pre class="ip-ubbcode-code-pre">GetSomeData(@SearchPhrase ...
Network World

SP1 Deja View? Excuse the pun…

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 ...
TechRepublic

SQL basics: SELECT statement options

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 ...