2008-09-22

SQL Server 2000 vs LOG and SQRT

If you attempt to take the LOG or SQRT of a negative number in SQL Server 2000, it fails quietly but catastrophically.  Should a query attempt to perform one of these operations, the result set is empty -- all rows are discarded.  No error is reported, neither to the client nor in the SQL Server logs.