Home Forums SQL Server 2012 SQL 2012 - General Adding columns to existing table RE: Adding columns to existing table<!-- 864 -->

  • August 21, 2014 at 12:50 pm

    #1740012

    You would have to deal with the non-dummy dates first. (Or if you can do it with a join?)

    Then you could just use something like

    UPDATE <tablename>

    SET someDate = '01-01-1900'

    WHERE someDate IS NULL