SQL Clone
SQLServerCentral is supported by Redgate
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, 523 reads

Posted in Dave Ballantynes blog on 6 September 2010