Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQs - Introduction to NULL Values

By: FYIcenter.com

A collection of 11 FAQs on working with NULL values. Clear explanations and tutorial exercises are provided on assigning NULL values to columns, variables and parameters; evaluating expressions with NULL values; testing NULL values; ISNULL() and NULLIF() functions. Topics included in this collections:

  1. What Are NULL Values?
  2. How To Assign NULL Values to Variables or Columns?
  3. What Happens If NULL Values Are Involved in Arithmetic Operations?
  4. What Happens If NULL Values Are Involved in String Operations?
  5. What Happens If NULL Values Are Involved in Datetime Operations?
  6. What Happens If NULL Values Are Involved in Bitwise Operations?
  7. What Happens If NULL Values Are Involved in Comparison Operations?
  8. What Happens If NULL Values Are Involved in Boolean Operations?
  9. How To Test NULL Values Properly?
  10. How To Replace NULL Values in Expressions using ISNULL()?
  11. How To Replace Given Values with NULL using NULLIF()?

Please note that all answers and tutorials are based on SQL Server 2005 Express Edition. To follow tutorial exercises in this collection, you need to use test tables created from previous tutorial collections.

(Continued on next topic...)

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...