Wise Owl's Blog
Making Sense of Software

Excel | Microsoft training in London, UK

Selecting data in SQL blogs

SQL Server Tutorial

Posted by Andrew Gould on 13 February 2012 | no comments
This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.
Tags:   SQL / Selecting data   |   SQL / WHERE criteria   |   SQL / Calculations   |   SQL / Joins   |   SQL / Grouping   |   SQL / Stored procedures   |   SQL / Transactions   |   SQL / CTEs, subqueries
Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.
Tags:   SQL / Selecting data   |   Access / Forms and subforms   |   ASP.NET / ADO.NET and data