Browse by Tags

Functions to Work with NULL Values

Today I was asked what was the replacement for the IIF command in MS Access and how to manage nulls in SQL Server. So I decided to write about nulls, not that I like to work with them...but sometimes we don't have a choice ;) SQL Server may generate unexpected results when performing calculations...

Posted to MS SQL Dev (Weblog) by Eric Vaillancourt on Thu, Apr 3 2008
How to Use Aggregate Functions with NULL Values

Effect of NULL Values on Aggregate Functions NULL values may cause aggregate functions to produce unexpected or incorrect results because these functions ignore NULL values for calculations. For example, if the Weight column of a table has 504 records, of which 299 records have NULL values, the average...

Posted to MS SQL Dev (Weblog) by Eric Vaillancourt on Wed, Apr 2 2008

Page 1 of 1 (2 items)