Broken SQL objects: Views, functions, stored procedures, triggers

Designing a perfect entity relationship diagram for our database together with a marvellous table structure is never good enough.. Have look at the following example (for MS SQL Server) creating two tables and a view:

A view, a function or something else, we try to write re-usable code so that we do not have … Read moreBroken SQL objects: Views, functions, stored procedures, triggers

Update Query on MS Access

Microsoft programmers are always very particular on their way of approaching problems. Since they are the “biggest” software developers in the world, they have to set the standards!? Problem: Updating field(s) of a table using a complex (sub) query. Solution: 1. In standard SQL, you can this:

It makes sense, right? No, not according … Read moreUpdate Query on MS Access