Learn something new every day

20 Aug
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 didn’t know you could do that. In fact I’m convinced that never used to be the case in SQL 2005 Management Studio.
Thanks Chris!

No Comments

Posted in Training


Leave a Reply