Archive for the ‘SQL’ Category

Select a Range in MS SQL

Select a Range in MS SQL

Posted on: November 4th, 2011 by deanpugh

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 […]

Quick SQL Copy Table

Quick SQL Copy Table

Posted on: November 3rd, 2011 by deanpugh

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, […]

SQL Custom Order

SQL Custom Order

Posted on: November 2nd, 2011 by deanpugh

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 […]