Madhivanan's TSQL Blog

Getting Started with ASP.NET MVC - Part 5: How to do programming with razor syntax

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Upload Image

Close it

Select File

Browse by Tags · View All

Archive · View All

Home · Posts · Most Liked · Most Discussed · Ask a Question · Images · Fans (203) · Preferences

Question of the month January 2012 - Datatype of NULL

Jan 11 2012 1:25AM by Madhivanan

Without running the following code , can you guess the datatype of the column t?

select null+getdate()+772.67 as t into #t5

Tags: SQL Server, #SQLServer, SQLServerPedia Syndication, Career,

Madhivanan

4 · 39% · 8773

Liked

Lifesaver

Refreshed

Learned

Incorrect


Like this
Post this to my facebook wall
Tweet this
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect

It will create datetime datatype for column t.

commented on Jan 13 2012 4:53AM .

sk2000

491 · 0% · 45

That's quite a misleading title !

The 'implicit' data-type of NULL is integer.
The 'implicit' data-type of the sum of an integer and a datetime and a decimal is a datetime.

The reason for the latter can be found in the documentation of

commented on Jan 14 2012 8:05AM .

Roby Van Hoye

184 · 1% · 193

Sign Up or Login to post a comment.