Skip to main content

Snippet: Show full column names and data types for all user tables in a database

SELECT QUOTENAME( sysobjects.name ) + ‘.’ + QUOTENAME( USER_NAME( sysobjects.uid ) ) + ‘.’ + QUOTENAME( syscolumns.name ) AS [Name] , TYPE_NAME( syscolumns.xusertype ) AS [Type] , syscolumns.prec AS [Precision] , syscolumns.scale AS [Scale] FROM syscolumnsINNER JOIN sysobjects ON syscolumns.id = sysobjects.idLEFT OUTER JOIN systypes ON systypes.xtype = syscolumns.xtypeWHERE sysobjects.xtype = ‘U’

Read More

Multiple domain names, one geeklog

Geeklog (the software driving this site) requires you to set the home url in config.php. I use multiple domain names here: juliankuiters.id.au julian-kuiters.id.au synthesisone.com so I wanted to configure geeklog to allow visitors to use the website through each of these domans. Geeklogs default behaviour is to prefix the value of $_CONF[‘site_url’] from config.php to […]

Read More

About time!

A long time coming, but finally I’ve gotten round to installing something I can post to from work and home without hassle. Ugly, yes I know. (Where’s the pink?) A new theme will come soon enough. Until I feel creative, you’ll have to put up with articles, snippets and the occasional frustrated punishing post. Till […]

Read More