MS SQL Dev

Browse by Tags

• Coalesce
• Count(*)
• null
• NullIf

• 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... Posted Apr 03 2008, 12:25 AM by Eric Vaillancourt with | with 1 comment(s) Filed under: Coalesce, NullIf, IsNull, null, Count(*), Aggregate

• 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... Posted Apr 02 2008, 08:49 PM by Eric Vaillancourt with | with 1 comment(s) Filed under: IsNull, null, Count(*), Aggregate