Selecting a range from a table is easy in MYSQL. Say you want to bring back results that you are paginating. Bringing back thousands of results is inefficient and needless.

MS SQL there isn’t a simple way of doing this. The best way I have found, or my colleague Daniel has found, is to wrap a select statement inside another statement.

Above is our full statement returning all our results. First, we need to add a row number which will allow us to know the result's position.

Select a Range in MS SQL

Just a quick SQL tip that I have been using recently, and is aimed mainly at MS SQL, but I cant see any reason why this wouldn’t work on MY SQL, except for the fact the MY SQL has easier Backup facilities.

The background for this is that I was making changes to a table, but wanted a backup of the latest version. Microsoft makes it ridiculously complicated to back up individual tables and restore them, and I didn’t have time to read manuals or try out third-party software.

The script below simply takes the entire table selected and copies it under a new name, giving you both tables to compare and rename/restore with ease.

I have since used this script several times and seems an easy way of making sure you don’t ruin a perfectly good table!

Quick SQL Copy Table

I recently had a problem while creating a list of players for a project. I needed to list them in a certain order based on their position.

I knew there were only 4 possible positions, but wanted them returned in the order of GK, DEF, MID and STK.

I managed to find two ways of doing this which I will demonstrate below.

The first way was to use an Order by. The script below orders the table first by my Custom order, and then by the ID Number field.

SQL Custom Order

I recently reloaded my computer and had to figure out how to add Camera Raw to Photoshop CS3. This should help you with whatever version you are using.

Firstly, you will need to download the Camera Raw, and a list of versions can be found on the 

. For versions above CS3, I think you can just download the installer and it will do everything for you. If not, follow my instructions which I used for CS3.

I found out that the latest version to work with CS3 was 4.6. So I downloaded the DLL. You will need to check to see which dll will work with your version, may be a bit of trial and error. Photoshop will complain about the plugin if you have an incompatible version. The newer versions allow for newer cameras.

Make sure that Photoshop is closed, and then navigate to c:\Program Files\Common Files\Adobe\Plug-Ins\CS3\File Formats. Rename the Camera Raw dll in this directory by adding .old to the end.

Now open up the zip file you downloaded from Adobe which contains the dll and copy this across to the folder that contained the original (the folder in the step above).

My programming musings that nobody else reads

Select a Range in MS SQL

Quick SQL Copy Table

SQL Custom Order

Adding Camera Raw to Photoshop