I would like to set up an SQL Trigger on an MS sql Database 2008. I'm sorry I'm not very familiar with T-SQL and I'm in the process of learning. How would I go about setting up a Trigger that Dynamically calculates a Field on insert?
([WATER_LENGTH] * [WATER_WIDTH] /43560) * [WATER_DEPTH]
This is the formula I would like to use to calculate the field [VOLUME_DIMEN]