SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

No More NULL

By Steve Jones,

One of the tricky things that developers new to SQL Server struggle with is the concept of NULL. Quite often I have seen people wonder why an empty string, or a zero, do no equate to NULL, or even why NULL does not equal NULL when searching. That fundamental idea of "unknown" just seems to be one that confuses many programmers.

The other day I was listening to a developer at Microsoft that is looking forward to SQL 11, and he let something slip. I suspect that this wasn't intended to get out, but it wasn't an NDA talk, and no disclaimers were given, so I don't think there is any reason I can't repeat it.

There won't be any NULL support in SQL 11.

No more worrying about ISNULL, or NULLIF, no more sticking in specialized code that deals with unknown values. Instead you'll need to actually put in data for all fields, relying on empty strings, or zeros, to signify missing data. The support for a "zero" date is still a work in progress, but it appears that strong support for "1/1/1900" as a base date is out there.

I think this is fantastic, and it will make developing databases much simpler in the future. Developers will no longer have to worry about missing information, and they'll just set a default value for all columns. I suspect that defaults will actually be required for all new fields in all tables, just to prevent errors. This also means that we'll get multi-table inset capabilities in views since all fields will have defaults and the order of values supplied will be used to populate rows in the base tables.

Of course, this is also an April Fool's joke and is in no way based on reality. It's entirely a work of fiction, and I hope you have a smile on your face at this point.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Total article views: 701 | Views in the last 30 days: 1
Related Articles

The Podcast is in the Windows Store

If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the...


Technical Podcasts I Listen To

There are a few podcasts I tend to listen to as I have time. Since I work with a wide...


Podcast Announcements

Podcast Feeds


Podcast Problem

Podcast Problem Blocked by group policy



A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...