Good question indeed!
The result would be same if, I replace the second insert statement with 0 (zero) from space.
insert into #test
select 1,'malli',null
union
select 2,'reddy',0
union
select 3,'test',getdate()
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter