Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: September 2010

An impossible case

In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.

When executing this code

Code Snippet
  1. select top(10) abs(checksum(newid()))%4       
  2. from sys.objects

the only possible values… Read more

0 comments, 222 reads

Posted in Dave Ballantynes blog on 6 September 2010