Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 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

Total article views: 692 | 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...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones