Monthly Archives: June 2015

Output sub query as CSV when Joining tables (one to many relationship)

This will show you how to get something like this from a table join and then I’ll explain how the SQL works. Name csv UK London,Manchester,Birmingham USA New Your,Washington,Kentucky France Paris,Leon,Frejus Suppose we have two tables — Create base table CREATE … Continue reading

Posted in Uncategorized | Leave a comment

Creating and Migrating an encrypted database.

This is a simple tutorial on how to… Create a database Setting up encryption Add encrypted data to a table Migrate the encrypted database to another server The tutorial is supplied without warranty and David Bridge and David Bridge Technology Limited accept … Continue reading

Posted in Uncategorized | Leave a comment