So today i decided to utilise my adsense account which i’ve had since 2004. I can’t remember the last time I actually
used it, but it hasn’t been active for quite awhile.
Anyway, I’ve put some ad code here and there and I thought to myself, wouldn’t it be great if I could detect when someone
clicked on [...]

Out with the old and in with the new. I finally decided to update my blogs look and feel. So jumping on the band wagon of web 2.0 icons, I started to re-design the site.

And here it is! It’s taken me about 30 hours of work and lots of late nights, but I’m quite happy [...]

Something I needed today… I wish this was standarized, but it is not, so here are some examples:
SQL Server:

SELECT TOP 10 product, descr, email
FROM products

ORACLE:

SELECT product, descr, email
FROM products
WHERE ROWNUM

The cult classic where Mr Benn is an ordinary man who goes to an unusual Fancy Dress Shop where he tries on an outfit and as if by magic he enters a world of adventure. The complete series plus a brand new episode.

Relive the classic programmes of your childhood or introduce this fantastic series to [...]

Sometimes I’ve had the need to use SQL to go and get table information i.e is a field varchar or int etc.

For MS SQL server you can use the following to get info on a table

SELECT RIGHT(syscolumns.name, LEN(syscolumns.name)) AS dbFieldName, systypes.name AS typename, syscolumns.length AS maxlength, syscolumns.xprec AS [precision], syscolumns.xscale AS scale, syscolumns.isnullable AS isnullable
FROM [...]