Learn something new every day

One of the Tech Support guys in the office had the need to set a date in a SQL 2008 database record to null. Not knowing TSQL, he used SQL Management Studio edit view to type in 'NULL' into the date field.

Watching him as he typed, I was about to say something deep and meaningful about strings into date fields, and that he should use ctrl-0 instead, but before I could, he had tabbed out of the field and it was accepted as a null value!

I didnt know you could do that. In fact I'm convinced that never used to be the case in SQL 2005 Management Studio.

Thanks Chris!