• Try this. I will not update but generates the script for update columns

    select '[' + name + '] = 0'

    from sys.columns

    WHERE object_id = OBJECT_ID(N'[dbo].[myTable]')

    and name != 'CustCode'

    Thanks