Home » Tips
SQL Tips – List of New Zealand Towns and Cities
Here is SQL and a text list of the towns and cities in New Zealand. The list is free for all to use for any purpose. The original data was sourced from Wikipedia on Saturday 31 January 2008….
Read More »SHA256 and higher in SQL Server
As part of a new project I’m doing, I needed to use hashes. A good source of information on hashes is available from wikipedia. SQL has the built in function HASHBYTES but this only supports up to the…
Read More »SQL Tips – List of US States
Here is SQL and a tab delimited list of the States of the USA for all to use. The original data was sourced from Wikipedia. Please post a comment if you find this useful. Edit: I’ve beed advised…
Read More »SQL Tips – List of Countries
This data was published in 2009 and is understandably out of date. Click here for an updated (2018) revision. Here is SQL and a tab delimited list of Countries for all to use. The original data was sourced…
Read More »SQL Tips – List of International Dialling Codes (IDC's)
I’ve been working on a new project and needed a list of International Dialling Codes to insert into my database. Here are the results of my work for all to use. The list is supplied as SQL and…
Read More »SQL Tips – Saving Changes Not Permitted
If you’re new to SQL 2008, you’ve probably seen the following message: The error reads: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made…
Read More »SQL Performance – Using LOWER() on case insensitive collations
Take a look at the following SQL. SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = ‘john’SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = ‘john’ The above SQL is Syntactically correct. But, and this is a big but, unless…
Read More »Getting a 1 Pixel high DIV in IE6
For a web designer, IE6 is a real prick of a browser. You are constantly having to use hacks on CSS to make it work for just one browser, which is now over seven years old. I was…
Read More »Backing up SVN to a Zip File
I promised in my post about getting a UTC Formatted Date and Time from the command line that I would give some tips about using it for backups. I use my dateTimeUTC command line application I wrote about…
Read More »Easy Formatted UTC Dates from the Command line – PC
I’ve been using the command line to backup my files for a long time, but always used the date and time tools that ship with windows. the way I used to do it was like this (Sorry, long…
Read More »