I believe the CASE function with INSERT & UPDATE will still meet the OP's requirements..

Cheers

Not sure if I understood your requirements but if you just want to pass 0 to columns while inserting/updating data, don't you think it would be easier to ALTER the...