Subscribe to this blog
Archives: August 2010
Kent SqlServer UserGroup
I am now in the process of arranging the 2nd meeting of the kent sqlserver user group. This will be on the 22nd September at the Style and Winch in Maidstone.
If you wish to give a short "nugget" (a 5-10 minute presentation) of a feature of the sqlserver product… Read more
0 comments, 85 reads
Posted in Dave Ballantynes blog on 27 August 2010
Kent SQL Server User Group
Well , that was an experience.
It was my first time arranging anything like that and it seemed to me that everything came together in the end ok. Things didn't quite go according to plan when I was delayed setting up by the filming of a Jack the Ripper drama… Read more
0 comments, 138 reads
Posted in Dave Ballantynes blog on 19 August 2010
Inconsistent NullIF Behaviour ?
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the two parameters are equal then null is returned. So if we execute :
- Select nullif(10,10) as Result1
- Select nullif(10,9
2 comments, 142 reads
Posted in Dave Ballantynes blog on 6 August 2010