Computed columns Data Types

Question

Post reply

Computed columns Data Types

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Dana Medley SSCertifiable Points: 6764 More actions · Answer 1

Good question. Learned something today which always makes for a good Friday. 🙂

Everything is awesome!

sqlnaive SSCoach Points: 17437 More actions · Answer 2

Nice QOTD Raul. 🙂

I didn't give it a though and straightforwardly clicked the answer but just after clicking (in split of seconds before showing teh result), i thought i didn't even give it enough time. Luckily it was without any issues correct one. Need to keep little more patience. 🙂

TGIF... 🙂

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Bob Cullen-434885 (11/15/2013)
Raul, Gaz, thanks both. I should have known better than to assume SQL would apply some intelligence to the expression analysis! 😉
Odd, though, in the table designer, how the 'Allow Nulls' and 'Data Type' attributes get blanked for computed columns - no hints at all there about what is going on in its tiny mind...

It would probably not be a bad thing if MS got to know that a lot of people think that this grossly oversimplified rule for computed column nullability is silly. I doubt if it would actually do any good, though.

Anyway, a nice easy question to end the week.

Tom