SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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, 411 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, 647 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 :

Code Snippet
  1. Select nullif(10,10) as Result1
  2. Select nullif(10,9

Read more

2 comments, 648 reads

Posted in Dave Ballantynes blog on 6 August 2010