Set Insert Date and Prevent Update 1

[larrydavid]

Hello, I have a two-part question:

First:
I need to override whatever value (or null) is entered for an [insert date] field.

Second:
I need to prevent any future update on this field and lock it.

I was thinking of a trigger or constraint-based solution, but thought I might ask here first to see if there might be a better solution. I am trying to avoid adding as much as possible because we will be cloning these tables in the future. Any advice would be appreciated.

Thanks,
Larry

 

[markros]

The only possibility I see here is to use either trigger after insert/update or INSTEAD OF trigger.

PluralSight Learning Library

 

[Auguy]

Just a quick thought. Can you set up a bit field and initialize it to zero and set it to 1 when the date is updated. then don't allow any updates to the date if the bit field is 1?

Auguy
Sylvania/Toledo Ohio