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'm joining two tables, one is a list of links and the other is a list of categories. The links are organized using a category ID. I would like to select all the links, and break them into category ...

Complex queries can be solved with a combination of simpler LINQ queries, anonymous objects and the Group/By/Into clauses. Using Group/By/Into will also give you the best possible performance for ...

Last month I told you about the overall set of features which Microsoft plans to release when SQL Server 2014 (SQL2014) is released to manufacturing. Microsoft has three major feature sets that they ...