Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: is null

Working with NULL values

NULL is an undefined value and as such, it has a special status as values and datatypes go in SQL Server. There are quite a few potential pitfalls to watch out for when you’re dealing with data that can contain NULL values.

Continue reading Working with NULL values
Published 2014-03-23
Categorized as Basics, T-SQL Tagged ansi_nulls, coalesce, compare, concat_null_yields_null, div0, divison by zero, is not null, is null, isnull, null, nullif, undefined
sqlsunday.com
Proudly powered by WordPress.