Home Forums SQL Server 2005 SQL Server 2005 General Discussion Can I use a case statement in a column default? RE: Can I use a case statement in a column default?

  • August 2, 2011 at 12:19 pm

    #1362471

    srferson-957148 (8/2/2011)

    Oh, yeah. I've used case statements in computed columns before. That's actually part of the reason I was hoping there was a way to do it in default. But you're right. The fact that computed columns can't be updated is a problem in this case.

    Looks like I'm going to have to go with a trigger.

    Thanks everyone!

    Why would you want the computed column to be updated?? That kind of defeat the purpose!