Computed columns Data Types

  • Dana Medley

    SSCertifiable

    Points: 6764

    Good question. Learned something today which always makes for a good Friday. πŸ™‚



    Everything is awesome!

  • sqlnaive

    SSCoach

    Points: 17435

    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: 104772

    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

  • Hany Helmy

    SSChampion

    Points: 13436

    Definitely learnt something new today, thanks.

  • Ford Fairlane

    SSCertifiable

    Points: 7664

    Good Q, thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    Thanks for the question!

    Best Regards,

    Chris BΓΌttner

  • ksatpute123

    Hall of Fame

    Points: 3325

    Fantastic question. Thank you.

  • Revenant

    SSC-Forever

    Points: 42467

    A headscratcher, and a good one. Thanks, Raul!

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    Good question.. learned new thing

  • matt.akers.1

    SSC Veteran

    Points: 211

    Didn't know you could do a sp_help on a temp table. Thanks for the question!

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

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