Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Blogs by David Wakefield

Dynamic SQL - No, No, No!

Posted by David Wakefield on 02 July 2012 | no comments
Dynamic SQL should only be used as a last resort. This article gives you a tip for avoiding the use of dynamic SQL in WHERE clauses
Tags:   SQL / Selecting data   |   SQL / WHERE criteria   |   SQL / Dynamic SQL

Link SQL Views to MS Access using VBA

Posted by David Wakefield on 26 June 2012 | no comments
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
Tags:   SQL / Views   |   Access / Importing and linking
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

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.